PDA

View Full Version : Solved: Summing of Totals



JKwan
08-21-2009, 08:42 AM
I am wondering what is the easiest way to sum the attached sample data?

I need to sum by Satellite then Battery Names - VBA would be preferred method.

I tried Subtotal, I wasn't satifsied with the end result. Because I need to read / pick off the total into another sheet.

Thanks

Bob Phillips
08-21-2009, 08:58 AM
=IF(OR($A2<>$A3,$B2<>$B3),SUMPRODUCT(--($A$2:$A2=$A2),--($B$2:$B2=$B2),E$2:E2),"")

copy across and down

JKwan
08-21-2009, 09:28 AM
As usual, thanks a million