| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum up cells in column A that has same text in Column B.
Hi! you can use sumproduct approach like =sumproduct(($b:$b=$b1)*($a:$a)) "Ms-Exl-Learner" wrote: just paste this formula in C1 Cell. =SUMIF($B:$B,$B1,$A:$A) If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- "Nick Ng" wrote: Hi everyone, I was wondering if someone could help me out with an Excel problem. Assuming I have two columns like below: A B -- -- 22 C1234 12 C5678 8 C9012 10 C5678 51 C5678 63 C1234 87 C1234 14 C9012 etc.... How can I create a formula to automatically sum up those values of column A, which have similar values in column B. For example, for column B = C1234, the sum is 172 (22+63+87). Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum up cells in column A that has same text in Column B.
But that formula would only work in xl2007.
(It would work in earlier versions if the entire column were not used.) sheryarkhan wrote: Hi! you can use sumproduct approach like =sumproduct(($b:$b=$b1)*($a:$a)) "Ms-Exl-Learner" wrote: just paste this formula in C1 Cell. =SUMIF($B:$B,$B1,$A:$A) If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- "Nick Ng" wrote: Hi everyone, I was wondering if someone could help me out with an Excel problem. Assuming I have two columns like below: A B -- -- 22 C1234 12 C5678 8 C9012 10 C5678 51 C5678 63 C1234 87 C1234 14 C9012 etc.... How can I create a formula to automatically sum up those values of column A, which have similar values in column B. For example, for column B = C1234, the sum is 172 (22+63+87). Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add Same Text to All Cells in Column | Excel Discussion (Misc queries) | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| How do I append same text to all the cells in a column at once? | Excel Worksheet Functions | |||
| COUNTING TEXT CELLS IN A COLUMN | Excel Worksheet Functions | |||
Hybrid Mode
