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

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,