| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Data based upon a condition
Hi,
Trying to "Sum" data in one column (A) based upon a condition in another column (B)....... Any help? -- Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing Data based upon a condition
Take a look SUMIF function in help menu
"Chris" wrote: Hi, Trying to "Sum" data in one column (A) based upon a condition in another column (B)....... Any help? -- Chris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing Data based upon a condition
Hi,
Let's assume you want to sum column B if column A equals customer "A" =sumproduct(--($A$1:$A$1000="A"),$B$1:$B$1000) "Chris" wrote: Hi, Trying to "Sum" data in one column (A) based upon a condition in another column (B)....... Any help? -- Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing rows based upon condition | Excel Discussion (Misc queries) | |||
| Summing data based on criteria | Excel Discussion (Misc queries) | |||
| Summing Up Data Based on Codes | Excel Worksheet Functions | |||
| Summing Data based on Its Category | Excel Discussion (Misc queries) | |||
| Summing an array based on text condition | Excel Discussion (Misc queries) | |||
Hybrid Mode
