[paulelsa]

I am doing a rainfall chart and want Excel to count the number of days in each month with rain. Unfortunately there are 31 days in some months so I get the error message "more arguments have been specified for this function than are allowed in the current file format" when I get to number 31.

I am using the formula =SUM(COUNTIF(B2,"<>0.0"),COUNTIF(B3,"<>0.0"),COUNTIF(B4,"<>0.0"),COUNTIF(B5,"<>0.0"),COUNTIF(B6,"<>0"),COUNTIF(B7,"<>0"),COUNTIF(B8,"<>0"),COUNTIF(B9,"<>0"), etc etc to B32

Is there a way to overcome this problem?

[Advertisements]

Obviously, I can't see the structure of your spreadsheet but why not use something like =COUNTIF(range,criteria)
(You don't need to sum each entry, use a range.)

So you could have =COUNTIF(B2:B32,">0") to show the days when it rained.

You could have the formula refer to another cell where you input the rain level e.g. =COUNTIF(B2:B32,A1)
and in A1 you type, for example, >1 to count the days when more than 1 inch/millimetre fell.

[Vino Rosso]

Obviously, I can't see the structure of your spreadsheet but why not use something like =COUNTIF(range,criteria)
(You don't need to sum each entry, use a range.)

So you could have =COUNTIF(B2:B32,">0") to show the days when it rained.

You could have the formula refer to another cell where you input the rain level e.g. =COUNTIF(B2:B32,A1)
and in A1 you type, for example, >1 to count the days when more than 1 inch/millimetre fell.

[paulelsa]

Perfect, thank you. Worked like a charm

[Vino Rosso]

You're welcome