| 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 | |||
Hybrid Mode
