countif vs. if????

[Tflight]

Hi,

I am trying to figure out a formula that will calculate the number of cells
that have a number greater than 0 in one cell and then a few columns over has
the word "Low" in it.

Right now, I have COUNTIF(L6:L327,"Low",IF(G6:G327,">0")) and of course I
did something wrong to it because there's an error message.

I'm not sure if explained this welll enough. Please help.....

 

[Mike H]

Try this,

=SUMPRODUCT((L6:L327="Low")*(G6:G327>0))

Mike

 

[Gary''s Student]

Any time you need to deal with more than one criteria, always consider
SUMPRODUCT(). In this case:

=SUMPRODUCT((L6:L327="Low")*(G6:G327>0))

 

[Tflight]

That worked perfectly. Thanks. I looked up the sumproduct description, but it
really didn't make any sense. Could you explained why that worked?

 

[Gary''s Student]

http://www.exceluser.com/explore/sumproduct_11.htm

 

[Tflight]

Thank you!

http://www.exceluser.com/explore/sumproduct_11.htm

 

[Shane Devenshire]

Hi,

If you are using Excel 2007 you can also consider

COUNTIFS(L6:L327,"Low",G6:G327,">0")

Excel 2007 also supports SUMIFS, and AVERAGEIFS