60614_Excel
Board Regular
- Joined
- Jan 5, 2003
- Messages
- 55
Hi, I am trying to do a COUNTIF based on two different variables. Basically in Column A I have an animal type and in column B I have the # of animals. So, I want to COUNTIF Col A = DOG and if COL B > 0.
I tried to do a COUNTIF(AND(... but I keep getting errors. Any ideas? Thanks in advance!
I tried to do a COUNTIF(AND(... but I keep getting errors. Any ideas? Thanks in advance!