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,

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



"Daniel Q." wrote in message
...
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,

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

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,