groundcontrol
New Member
- Joined
- Feb 7, 2005
- Messages
- 3
I need to count the number of cells that satisfy two criteria. I.e. that are both x (listed in column "A") and y (listed in column "B"). So I've tried various combinations of COUNTIF and AND, to no avail.
For example: COUNTIF(AND((A1:A100,"x"),(B1:B100,"y")))
Any help/pointers greatly appreciated!
For example: COUNTIF(AND((A1:A100,"x"),(B1:B100,"y")))
Any help/pointers greatly appreciated!