Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
I'm trying to add the number of cells that contain a series of numbers. I.E.
From E2:E24 add the number of cells containing 100% and total in E26. for the same range count the number of cells containing numbers from 90% - 99% in cell E27. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
do you want to add what is in the cells themselves togehter or just count how
many cells contain the data you are checking for? "rhbm" wrote: I'm trying to add the number of cells that contain a series of numbers. I.E. From E2:E24 add the number of cells containing 100% and total in E26. for the same range count the number of cells containing numbers from 90% - 99% in cell E27. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Hi,
try =COUNTIF(E2:E24,"0.9")-COUNTIF(E2:E24,"0.99") for the number of values between 90% and 99% Regards, Ingolf rhbm schrieb: I'm trying to add the number of cells that contain a series of numbers. I.E. From E2:E24 add the number of cells containing 100% and total in E26. for the same range count the number of cells containing numbers from 90% - 99% in cell E27. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
count how many cells
-- rhbm "tim m" wrote: do you want to add what is in the cells themselves togehter or just count how many cells contain the data you are checking for? "rhbm" wrote: I'm trying to add the number of cells that contain a series of numbers. I.E. From E2:E24 add the number of cells containing 100% and total in E26. for the same range count the number of cells containing numbers from 90% - 99% in cell E27. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
That worked! Thank you very much!
-- rhbm "Ingolf" wrote: Hi, try =COUNTIF(E2:E24,"0.9")-COUNTIF(E2:E24,"0.99") for the number of values between 90% and 99% Regards, Ingolf rhbm schrieb: I'm trying to add the number of cells that contain a series of numbers. I.E. From E2:E24 add the number of cells containing 100% and total in E26. for the same range count the number of cells containing numbers from 90% - 99% in cell E27. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |