| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
trying to find formula
cells AP6:AP30 has data it could = to 2 to 8 when entered Now if i enter
data in cells AS6:AS30 I AM COUNTING these CELLS in AS31 IT could = to 1 to 4 So what i want to do is to have AS31 Multiplied by the least amount of the cells AP6:AP30 whitch might be 2 to 8 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
trying to find formula
Hi Mike,
Not sure that I have interpretted your question correctly but it appears that you want to find the minimum value in the range AP6:AP30 and multiply that by the count of cells containing values in range AS6:AS30. If my assumption is correct then the following will return the minimum value. =MIN(AP6:AP30) If in cell AS31 you are counting cells with values in range AS6:AS30 then I assume you are using the following =COUNT(AS6:AS30) Therefore =COUNT(AS6:AS30)*MIN(AP6:AP30) should return what you want. -- Regards, OssieMac "Mike" wrote: cells AP6:AP30 has data it could = to 2 to 8 when entered Now if i enter data in cells AS6:AS30 I AM COUNTING these CELLS in AS31 IT could = to 1 to 4 So what i want to do is to have AS31 Multiplied by the least amount of the cells AP6:AP30 whitch might be 2 to 8 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
trying to find formula
This is good but i do have zero values in cells AP6:AP30 that i need to avoid
"OssieMac" wrote: Hi Mike, Not sure that I have interpretted your question correctly but it appears that you want to find the minimum value in the range AP6:AP30 and multiply that by the count of cells containing values in range AS6:AS30. If my assumption is correct then the following will return the minimum value. =MIN(AP6:AP30) If in cell AS31 you are counting cells with values in range AS6:AS30 then I assume you are using the following =COUNT(AS6:AS30) Therefore =COUNT(AS6:AS30)*MIN(AP6:AP30) should return what you want. -- Regards, OssieMac "Mike" wrote: cells AP6:AP30 has data it could = to 2 to 8 when entered Now if i enter data in cells AS6:AS30 I AM COUNTING these CELLS in AS31 IT could = to 1 to 4 So what i want to do is to have AS31 Multiplied by the least amount of the cells AP6:AP30 whitch might be 2 to 8 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find formula for.... | Excel Worksheet Functions | |||
| Find Formula | Excel Worksheet Functions | |||
| Need to find a formula | Excel Worksheet Functions | |||
| Using IF/And in a formula to find a value | Excel Discussion (Misc queries) | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Hybrid Mode
