How to sum all values in a column where >0?

[Brovashift]

Hello again...

As per title, how can I sum all values (currency) in a particular column, where specific name text is found in Column A?

e.g. I am getting totals of the L column by using: =SUMIF(A:A,"wh",L:L)

Now I want to do the same thing but only for values greater than 0. Something like; =SUMIF(A:A,"wh",(L:L>0))

Thanks

Office Excel 2007

 

[Fluff]

How about

=SUMIFS(L:L,L:L,">0",A:A,"wh")

 

[FormR]

Hi, you can try.

=SUMIFS(L:L,A:A,"wh",L:L,">0")

 

[Brovashift]

Thank you, they both work great

Why do they both sum the L:L column twice... out of curiosity?

 

[FormR]

Why do they both sum the L:L column twice

The arguments for SUMIFS() are sum_range, criteria_range, criteria, critera_range, criteria, etc etc - you want to use column L for both the sum_range and also one of the criteria ranges.

 

[Brovashift]

The arguments for SUMIFS() are sum_range, criteria_range, criteria, critera_range, criteria, etc etc - you want to use column L for both the sum_range and also one of the criteria ranges.

Ah OK, excellent, Thank you...