|
| 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
November 17th, 2009, 09:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Auto sum 2 adjacent row data into 3rd row?
I have a list of people's names in column C and cost data for each person in
column M and N. Is there was to provide a subtotal of all cost data for each person in Column O? i.e.: row 1 Smith, John 100.00 440.00 row 2 Smith, John 300.00 row 3 Smith, John 40.00 row 4 Bird, Joe 50.00 500.00 row 5 Bird, Joe 450.00 Thank you in advance!  
|
|
#2
November 17th, 2009, 09:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto sum 2 adjacent row data into 3rd row?
in C2, =IF(C1=C2,"",sumif(C:C,C2,M:M)+sumif(C:C,C2,N:N))
"Tacrier" wrote: I have a list of people's names in column C and cost data for each person in column M and N. Is there was to provide a subtotal of all cost data for each person in Column O? i.e.: row 1 Smith, John 100.00 440.00 row 2 Smith, John 300.00 row 3 Smith, John 40.00 row 4 Bird, Joe 50.00 500.00 row 5 Bird, Joe 450.00 Thank you in advance!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
