subtotal data from 2 columns into 3rd column
 

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! :)

subtotal data from 2 columns into 3rd column
 

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

"Tacrier" wrote:

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! :)