Formula with multiple critera

[jjohnsonofduluthMN]

Hello,
I am trying to sum one column but need to pull critera from two different
columns. Does anybody have any suggestions?

Here's an example.

Coulmn A has property codes 33-40-41 etc..., coulmn B has the dollar amount
and coulmn C has if it is an F=fixed asset or N=non fixed asset. I need to
sum the dollar amounts in column B only if coulmn A = 33 and coulmn C=F (see
below) My total should be $1300.00. Is there a way without using a pivot
table?

A B C
33 50.55 N
40 100.25 F
40 200.00 N
33 800.00 F
33 500.00 F

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A2:A6=33),--(C2:C6="F"),B2:B6)

Better to use cells to hold the crieria:

E2 = 33
F2 = F

=SUMPRODUCT(--(A2:A6=E2),--(C2:C6=F2),B2:B6)

 

[Gary''s Student]

Anytime you need to address multiple criteria, consider using =SUMPRODUCT().

It's like SUMIF() on steriods.

=SUMPRODUCT((A1:A10=33)*(C1:C10="F"),(B1:B10))

For more information:

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