excel 2003 question

C

CorinDarksoul

I am trying to count conditional data that is true in 2 columns. Such as If
column = green and column b = south then count it. I need it to go through
about 100 rows of data and have it tell me how many times I get a true on
both conditions. Any ideas? I have tried nesting an if statment in a
countif, and vis versa, and also tried nesting some ifs, but to no avail.
Any help would be great!!!
 
B

Barb Reinhardt

Let's say your data for GREEN is in A1:A100 and the data for SOUTH is in
B1:B100

=sumproduct(--(A1:A100="green"),--(B1:B100="south))
 
B

Barb Reinhardt

Correction:

=sumproduct(--(A1:A100="green"),--(B1:B100="south))

should be

=sumproduct(--(A1:A100="green"),--(B1:B100="south"))
 
C

CorinDarksoul

Thank you thank you!! this solved my problem and gave me the answer I needed!
I may get my report done on time now!

Thanks again!!
 
Top