Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using macro or other function
Hi
I want to add the values of column A in 2 groups. One total would be adding the values of the rows that have 20 on the column B and other total would be adding the values which have 40 on the column B. The result should be 20 - 13 and 40 - 88 A B 2 20 1 40 84 40 6 20 3 40 5 20 Could anyone help me with this issue. Thanks in advance. Escarly |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using macro or other function
Use the SumIf function
=SUMIF(B1:B6,20,A1:A6) change the 20 to a 40 for the other one -- -John Please rate when your question is answered to help us and others know what is helpful. "orquidea" wrote: Hi I want to add the values of column A in 2 groups. One total would be adding the values of the rows that have 20 on the column B and other total would be adding the values which have 40 on the column B. The result should be 20 - 13 and 40 - 88 A B 2 20 1 40 84 40 6 20 3 40 5 20 Could anyone help me with this issue. Thanks in advance. Escarly |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using macro or other function
Thanks John, I rated.
"John Bundy" wrote: Use the SumIf function =SUMIF(B1:B6,20,A1:A6) change the 20 to a 40 for the other one -- -John Please rate when your question is answered to help us and others know what is helpful. "orquidea" wrote: Hi I want to add the values of column A in 2 groups. One total would be adding the values of the rows that have 20 on the column B and other total would be adding the values which have 40 on the column B. The result should be 20 - 13 and 40 - 88 A B 2 20 1 40 84 40 6 20 3 40 5 20 Could anyone help me with this issue. Thanks in advance. Escarly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Macro within a function? | Excel Worksheet Functions | |||
Macro Function | Excel Worksheet Functions | |||
Function or macro? | Excel Worksheet Functions | |||
How Do I (Macro Function)? | Excel Worksheet Functions |