excel 2003 question

[Guest]

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!!!

 

[Guest]

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))

 

[Bernard Liengme]

=SUMPRODUCT(--(A2:A200="green"),--(B2:B200="south))
for details see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Guest]

Correction:

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

should be

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

 

[Guest]

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!!

 

[Guest]

Thank you very much! This is the answer I was looking for.