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


"CorinDarksoul" wrote:

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