| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help in counting and summing cells based on multiple conditions
I have a spreadsheet I use for sales management and need help with 3 formulas
I cannot figure out. Following is what I am trying to do: 1. If the value in cells A1:A100=1 and the value in cells B1:B100=Yes and the value in cells C1:C100=Prime, count the cells in D1:D100 that have a value in them. (column D contains numbers.) 2. Same as number 1 but instead of counting, sum the cells in D1:D100 that have a value in them. 3. If the value in cells A1:A100=1, then count the cells in D1:D100 that have a value in them. (column D contains numbers.) Any help would be greatly appreciatied! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Based on Conditions using Array | Excel Discussion (Misc queries) | |||
| Counting rows based on the contents of multiple cells | Excel Worksheet Functions | |||
| Counting values based on multiple conditions | Excel Worksheet Functions | |||
| Conditionally summing cells based on conditions in other rows | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
