| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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!  |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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 | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Auto fill adjacent cells | KenM | Microsoft Excel Misc | 3 | 21st Nov 2008 02:29 AM |
| Auto fill Adjacent cells | =?Utf-8?B?U2ltb24gQmxhY2tidXJu?= | Microsoft Excel Worksheet Functions | 7 | 27th Sep 2007 04:50 PM |
| When data match, copy adjacent value to adjacent column | =?Utf-8?B?c2xpbWJpbQ==?= | Microsoft Excel Worksheet Functions | 2 | 8th Nov 2006 08:41 PM |
| Auto date/time insert when data entered into an adjacent cell | =?Utf-8?B?QXV0byBkYXRlL3RpbWU=?= | Microsoft Excel Worksheet Functions | 1 | 9th Jul 2005 12:10 AM |
| Function or Formula to auto complete adjacent data | Allan Barr | Microsoft Excel Worksheet Functions | 2 | 27th Aug 2003 09:29 PM |
