Countif question

Copper Contributor

Good afternoon, How would you alter the formula What if you need to count certain columns/cells but they are not a running range, for example: A1, C1, E2 not A1:E2?

4 Replies


Add the separate counts together.

Thank you when I did, I got the error: You've entered too few arguments for this function


Use comma instead of equals:



Thank you sooooo much!