Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula writing
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula writing
Try this:
Entered in C1 and copied down as needed: =IF(A1=A2,"",SUMIF(A$1:A1,A1,B$1:B1)) -- Biff Microsoft Excel MVP "Soth" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula writing
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 |
#4
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 |