excel 2003 question
 

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

excel 2003 question
 

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

excel 2003 question
 

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

excel 2003 question
 

Correction:

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

should be

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


"Barb Reinhardt" wrote:

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

excel 2003 question
 

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

excel 2003 question
 

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

"Barb Reinhardt" wrote:

Correction:

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

should be

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


"Barb Reinhardt" wrote:

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