If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|