| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF Function Formula Question | Excel Worksheet Functions | |||
| countif question | Excel Discussion (Misc queries) | |||
| CountIf formula question | Excel Discussion (Misc queries) | |||
| Countif formula question | Excel Discussion (Misc queries) | |||
| I have a question regarding countif formula. | Excel Worksheet Functions | |||
Hybrid Mode
