SUMIF / IF

D

Daniel Q.

I have a spreadsheet with different data in multiple columns. Depending on
whether those columns have certain criteria i need to sum a different column.

A B C D
E
1 TS NYMEX FP_FIN 2500 $10,000
2 TPORT NYMEX FP_FIN 2500 -$50,000
3 TS AECO BASIS_FIN 2500 -$40,000
4 TS MALIN BASIS_FIN 2500 $5000
5 TS HSC BASIS_FIN 2500 $2500
6 TS NYMEX FP_FIN 10000 $4500

i would like to sum column E based on what A, B and C say - A has to equal
"TS", B - "NYMEX" and C-"FP_FIN" to add rows 1 and 6.

I've been juggling vlookups, sumifs and ifs in my head but i can't seem to
figure it out.

Thanks,
 
B

Bob Phillips

=SUMPRODUCT(--(A1:A6="TS"),--(B1:B6="NYMEX"),--(C1:C6="FP_FIN"),E1:E6)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
M

Marcelo

=sumproduct(--(A1:A6="TS")*(B1:B6="NYMEX")*(C1:C6="FP_FIN"),(E1:E6))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Daniel Q." escreveu:
 
D

David Biddulph

Are you sure you need the double unary minus before the first term, Marcelo?
Doesn't the multiplication force the conversion from true/false to 1/0 ?
 

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