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.
...
or
=SUMPRODUCT(COUNTIFS(A1:A12,{"January","February","March","July","August","September"},B1:B12,1))
=SUMPRODUCT(COUNTIFS(A1: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.