| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula writing
Perfect ! Thank you Luke.
"Luke M" wrote: In C2: =IF(COUNTIF(A$2:A2,A2)1,"",SUMIF(A:A,A2,B:B)) This will give you totals as the first instance of a repeated value. Note that if your data is sorted, you might also want to look at Data -Subtotal as a way of quickly summarizing your data. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Soth" wrote: Hi- I'd need a formula in colum 'C'. If the number in colum A is matched, then sum-up the total,e.g 20 in column C; else return value in column B, e.g 5, and 15. A B = c 2006 10 2006 10 20 2111 5 5 2112 15 15 Regards, Soth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help writing a formula | Excel Worksheet Functions | |||
| Writing a Formula | Excel Discussion (Misc queries) | |||
| Need Help Writing a Formula | Excel Worksheet Functions | |||
| writing a formula | Excel Discussion (Misc queries) | |||
| I need help writing a formula. | Excel Worksheet Functions | |||
Hybrid Mode
