| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Sum of cells if conditions fulfilled
Hi all,
Trying to count or sum values from a range, if a condition is respected: A B Yes 25 No 12 Yes 11 So, I would like in cells being able to: - count cells if cell A is Yes (expecting then: count = 2, as A1 and A3 are yes, so B1 and C1 are counted) - sum cells if cell A is Yes (expecting then: sum= 36, as A1 and A3 are yes, so B1=25 + C1=11 are summed=36) Hope it's clear enough... thanks for help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to count relying upon conditions in other cells | Excel Discussion (Misc queries) | |||
| "Count If" 3 criterias are fulfilled | Excel Discussion (Misc queries) | |||
| Count Cells if diff cell meets conditions | Excel Worksheet Functions | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
Threaded Mode
