SUMIF ?

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am trying to creat a total based on the text contents
of two columns. SUMIF will work for one column but how
do I make it work for two? i.e. total field for each row
where A="Paul" and B="west" (each column has multiple
text values and I need total fields for each combination)
 
It looks like you want a multiconditional count:

=SUMPRODUCT((Range1="Paul")*(Range2="west"))

Whole columns (like A:A) are not allowed as ranges.
 
=SUMPRODUCT((A1:A100="Paul")*(B1:B100="west")*C1:C100)

will some the range in col. C that meet your criteria.

HTH
Jason
Atlanta, GA
 
Aladin Akyurek said:
It looks like you want a multiconditional count:

=SUMPRODUCT((Range1="Paul")*(Range2="west"))

Whole columns (like A:A) are not allowed as ranges.
Click to expand...

For a multiconditional sum...

=SUMPRODUCT((Range1="Paul")*(Range2="west"),RangeToSum)
 
Back
Top