Forum Discussion
Using SUMIF (SOM.ALS) or NUMBERIF (AANTAL.ALS) in case of not contiguous cells
My question is,
Which formula counts the numbers "1", but only for the ranges:
- January, february and march AND
- July, August and September.
Fot the clarity, the outcome should be 2.
...
Hi David,
Could be like
=SUMPRODUCT((A2:A12={"January", "February", "March", "July", "August", "September"})*(B1:B12=1))
Thank you for your recommandation.
When using the recommended formula, I get the error message: "The formula you typed contains an error." I don''t know what the error causes. In case of any suggestions, I like to hear them.
Hi David,
Please see both formulas attached. Range adjusted from B1:B12 to B2:B13