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.
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.
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.
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.
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.
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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks