Nesting a sumproduct formula within a sumif formula.

[jerrymcm]

Is this possible?

I want to write a formula that adds the values in column C, if the contents
of the corresponding cells in column A are less than a given value AND the
contents of the corresponding cells in column B contain a given text string.

Eg - Add up column C, if the cell in column A <20072 AND the cell in column
B contains "outlet".

Yesterday I got some great answers as to how to add up cells based on cells
containing a text string rather than equalling it, but now I need to nest
that within a sum if argument.

The formula I was given yesterday was....

=-SUMPRODUCT(ISNUMBER(SEARCH("outlet",B2:B100))*C2:C100)

Is it possible to nest this within a sum if argument, or should I go about
this in a totally different way?

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A100<20072),--(ISNUMBER(SEARCH("outlet",B2:B100))),C2:C100)


--


Regards,


Peo Sjoblom

 

[jerrymcm]

WOW.

Thanks.

=SUMPRODUCT(--(A2:A100<20072),--(ISNUMBER(SEARCH("outlet",B2:B100))),C2:C100)


--


Regards,


Peo Sjoblom