subtotal data from 2 columns into 3rd column

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

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top