Formula Question - CountIf?
 

I would like to do the following, but am at an impasse. I think this should
be simple, but it isn't working. Any help is very much appreciated!

I would like to find the following three categories from a column of data
(my data is in column B):

<=30 days
30 days but <=60 days
60 days

What formula would I use to find this data?

Thank you!!!

Formula Question - CountIf?
 

Not enough information.

<=30 days
30 days but <=60 days
60 days

What do those conditions apply to?

--
Biff
Microsoft Excel MVP


"RS" wrote in message
...
I would like to do the following, but am at an impasse. I think this
should
be simple, but it isn't working. Any help is very much appreciated!

I would like to find the following three categories from a column of data
(my data is in column B):

<=30 days
30 days but <=60 days
60 days

What formula would I use to find this data?

Thank you!!!

Formula Question - CountIf?
 

Given that your Subject line said Countif, and assuming column B had the
number of days in it, you would use:
=countif(B:B,"<=30")
=countif(B:B,"<=60")-countif(B:B,"<=30")
=countif(B:B,"60")

Regards,
Fred

"RS" wrote in message
...
I would like to do the following, but am at an impasse. I think this
should
be simple, but it isn't working. Any help is very much appreciated!

I would like to find the following three categories from a column of data
(my data is in column B):

<=30 days
30 days but <=60 days
60 days

What formula would I use to find this data?

Thank you!!!

Formula Question - CountIf?
 

Thank you so much for your assistance! I really appreciate it. RS

"Fred Smith" wrote:

Given that your Subject line said Countif, and assuming column B had the
number of days in it, you would use:
=countif(B:B,"<=30")
=countif(B:B,"<=60")-countif(B:B,"<=30")
=countif(B:B,"60")

Regards,
Fred

"RS" wrote in message
...
I would like to do the following, but am at an impasse. I think this
should
be simple, but it isn't working. Any help is very much appreciated!

I would like to find the following three categories from a column of data
(my data is in column B):

<=30 days
30 days but <=60 days
60 days

What formula would I use to find this data?

Thank you!!!

.

Formula Question - CountIf?
 

You're welcome. Thanks for the feedback.

Regards,
Fred

"RS" wrote in message
...
Thank you so much for your assistance! I really appreciate it. RS

"Fred Smith" wrote:

Given that your Subject line said Countif, and assuming column B had the
number of days in it, you would use:
=countif(B:B,"<=30")
=countif(B:B,"<=60")-countif(B:B,"<=30")
=countif(B:B,"60")

Regards,
Fred

"RS" wrote in message
...
I would like to do the following, but am at an impasse. I think this
should
be simple, but it isn't working. Any help is very much appreciated!

I would like to find the following three categories from a column of
data
(my data is in column B):

<=30 days
30 days but <=60 days
60 days

What formula would I use to find this data?

Thank you!!!

.