Formula with multiple critera

  • Thread starter jjohnsonofduluthMN
  • Start date
J

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top