Wikipedia:Reference desk/Archives/Mathematics/2017 October 19

= October 19 =

Using COUNTIF in Excel
Assume I have an Excel spreadsheet with data like this: I can find out the total for any given day of the week as the formula  (which returns 9.5) but how do I find out the count of non-blank entries in column B for a given day? I thought of, as in the formula   but it only accepts two arguments. What I want is something that for the example above will return a value of 2 for Monday and Thursday, and a value of 1 for Tuesday, Wednesday and Friday. -- Red rose64 &#x1f339; (talk) 21:16, 19 October 2017 (UTC)


 * Are you aware of the  function? It is just   but with multiple conditions. You should be able to use   to count how many Mondays there are with a positive value associated with them. AlfonsoAnonymous (talk) 01:33, 20 October 2017 (UTC)
 * , that worked. -- Red rose64 &#x1f339; (talk) 11:14, 20 October 2017 (UTC)

Location of question
Just wondering (and not angrily), is there any guidance to whether questions like this should be placed here or at RD:Computing? I'm thinking that Excel gurus might be more likely to watch RD:Computing (though apparently at least one watches here... :) ) Naraht (talk) 13:44, 20 October 2017 (UTC)