Hi All,
I got a sheet that is broken down by subtotals, but i need to sumproduct for 2 columns for each subtotals block. Below is the sample data...
I need to do sumproduct for columns B&D and C&E for each subtotal.
Any suggestions how can i do this.
Thank you
I got a sheet that is broken down by subtotals, but i need to sumproduct for 2 columns for each subtotals block. Below is the sample data...
hyld.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | AGYINC | 2921 | 0.596 | 7.543 | 310 | ||
2 | AGYINC | 721 | 0.147 | 9.733 | 527 | ||
3 | AGYINC | 452 | 0.092 | 7.287 | 290 | ||
4 | AGYINCTotal | 4094 | 0.835 | 24.563 | 1127 | ||
5 | DYINC | 2921 | 0.596 | 7.543 | 310 | ||
6 | DYINC | 721 | 0.147 | 9.733 | 527 | ||
7 | DYINC | 452 | 0.092 | 7.287 | 290 | ||
8 | DYINCTotal | 4094 | 0.835 | 24.563 | 1127 | ||
Sheet2 |
I need to do sumproduct for columns B&D and C&E for each subtotal.
Any suggestions how can i do this.
Thank you