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

"Bernard Liengme" wrote:

=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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"CorinDarksoul" wrote in message
...
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!!!