sumproduct using multiple criteria

[tifosi3]

I am having trouble summing when using multiple criteria. i.e. I want to
search column I for a certain product, then search column J for its place in
production (opened, approved, sent, returned) and then sum the corresponding
dollar amount from column B based on it's spot in production. I have done
similar things based on date/time stamps using isblank or isnumber, but
cannot seem to do it using a second text designation. Any help would be
appreciated.

 

[Dave R.]

This page should be of help;

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Aladin Akyurek]

Some options...

1] Build a pivot table from your data.

2] Use a formula for multi-conditional summing. One type would be:

=SUMPRODUCT(--(Irange=Product),--(Jrange=Status),Brange)

3] Resort to an additional column in the data area (e.g., column K) that
concatenates values in I with values in J...

K2, copied down:

=I2&","&J2

and then use a SumIf formula for single-condition summing:

=SUMIF(Krange,Product&","&Status,Brange)