Hi Everyone.
I have a table that looks like something like this:
How can I make it so that:
1 - Cell A10 counts only the cells that contains a date - so the total should be 3).
2 - Cell B10 counts only the green cells (or any other colour I choose) - so the total should be 2.
3 - Cell C10 counts only the cells that contain a text value I specify (e.g. 'C') so the total should be 2.
For that, I have this formula, is it correct?
=COUNTIF(C3:C5,"*C*")
4 - In cell D10 (not shown) it counts the cells that are orange or green from column A. So the total returned is 2.
Many thanks for your help.