subtotal data from 2 columns into 3rd column

  • Thread starter Thread starter Tacrier
  • Start date Start date
T

Tacrier

Is there a formula I can use to subtotal column data instead of using the
subtotal feature?

When I try using the subtotal feature it puts the subtotal at the bottom of
data. I would like to subtotal $ data located in Column M and N for each
change in a person's name in Column C. I would like this subtotal to show in
column O on the first row of each change in column C like this:

Column C Column M Column N Column O
John Smith 100.00 500.00
John Smith 300.00
John Smith 30.00
John Smith 70.00
Joe Bird 300.00 750.00
Joe Bird 30.00
Joe Bird 175.00
Joe Bird 245.00


Thank you in advance for your reply! :)
 
Hi,
You can have a list of your names and beside each one enter the formula as
follow, I assume your name is in column O

=SUMPRODUCT((O1=$A$1:$A$3000)*$B$1:$C$3000)

copy formula down

change range to fit your needs

if this helps please click yes thanks
 
Back
Top