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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|