Counting multiple cells with text

[dwm16]

I'm trying to find a way to count cells with text. Countif works if I'm only looking for one bit of text, but I can't figure away to do multiples. The tables below are a simplified version of what I'm trying to accomplish. Different people would enter text data using a validation list for each column, then at the end of the month, I want to count the number of occasions it was sunny and rainy in Fl, NY, and Tx in Jan, then Feb, etc.

I'm not sure if this makes sense or not, but i'm basically trying to write a formula that says: Countif (the data entry table has a "Jan" AND FL AND Sun) -- then put that count in the top left cell of the Jan "Results Table". Same with all the other cells in the results table (and there will be one results table for each of the 12 months).

Any help would be much appreciated. It doesn't have to be set up this way if there is an easier way.

Thanks.


DATA ENTRY TABLE
Jan FL Sun
Jan NY Rain
Jan FL Sun
Feb NY Rain
Feb NY Rain


RESULTS TABLE
JAN
Sun Rain
FL 2 0
NY 0 1
TX 0 0

 

[SIXTH SENSE]

hi!
use sumrpoduct() here

try this!

comb-perm2.xls
	A	B	C	D	E	F
1	Jan	FL	Sun		Jan
2	Jan	NY	Rain		Sun	Rain
3	Jan	FL	Sun	NY	0	1
4	Feb	NY	Rain	FL	2	0
5	Feb	NY	Rain	TX	0	0
Sheet4

 

[Brian from Maui]

I'm trying to find a way to count cells with text. Countif works if I'm only looking for one bit of text, but I can't figure away to do multiples. The tables below are a simplified version of what I'm trying to accomplish. Different people would enter text data using a validation list for each column, then at the end of the month, I want to count the number of occasions it was sunny and rainy in Fl, NY, and Tx in Jan, then Feb, etc.

I'm not sure if this makes sense or not, but i'm basically trying to write a formula that says: Countif (the data entry table has a "Jan" AND FL AND Sun) -- then put that count in the top left cell of the Jan "Results Table". Same with all the other cells in the results table (and there will be one results table for each of the 12 months).

Any help would be much appreciated. It doesn't have to be set up this way if there is an easier way.

Thanks.


DATA ENTRY TABLE
Jan FL Sun
Jan NY Rain
Jan FL Sun
Feb NY Rain
Feb NY Rain


RESULTS TABLE
JAN
Sun Rain
FL 2 0
NY 0 1
TX 0 0

Are your months true date values or just text?