Sumif question

  • Thread starter Thread starter lightbulb
  • Start date Start date
L

lightbulb

Is it possible to use a sumif function with two conditions? For Example,
SUMIF Column A = Past Due, AND Column B = Sum of Qty

Thanks!
 
An easier way might be to use SUMPRODUCT.

=SUMPRODUCT(--(A1:A100="Past Due"),--(B1:B100="Sum of Qty"),(C1:C100))

Anchor / expand the ranges as needed.
 
=sumproduct(--(a1:a10="past due"),--(b1:b10="sum of qty"),c1:c10)

Adjust the ranges to match--but you can't use whole columns (except in xl2007).

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

============
This sounds like you're working with data that is (or used to be) in a
pivottable.

Maybe you can just change the layout to get what you want.

Take a look at Debra Dalgleish's site:
http://contextures.com/xlVideo001.html
and
http://contextures.com/xlPivot02.html
 
Back
Top