SUMIF ?

[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)

 

[Aladin Akyurek]

It looks like you want a multiconditional count:

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

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

 

[Jason Morin]

=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]

It looks like you want a multiconditional count:

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

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

For a multiconditional sum...

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