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 ?
--
David Biddulph

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

"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,