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