Using COUNTIF function to count cells between values

andy5150

New Member
Joined
Aug 10, 2010
Messages
1
Hi,

I'm having a mental block that I'm hoping that someone can help with...

I have a column containing number of days to resolve a certain issue. What I'm looking to do is produce a summary tab to show the number within certain ranges (i.e. how many took between 1-10 days, 11-20 days, 21-30 days, etc).

How can I do this without the use of a Pivot Table? I'd imagine I'd need to get the countif function to look at multiple calculations, but just cant work out how to do it!

Any help would be very much appreciated.

Thanks,

A
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,416
If the number of days are in column B, this will count the number of entries in column B that are from 11 to 20

=COUNTIF(B:B, ">=11")-COUNTIF(B:B,">20")

If you have Excel 2007 or later, you could use the COUNTIFS function instead

=COUNTIFS(B:B, ">=11", B:B,"<=20")
 

nerojr

New Member
Joined
May 18, 2009
Messages
31
Sorry to piggy back, but I also have a COUNTIF? Can you create a formula using COUNTIF that will exclude the weekends when trying to count data. I'm looking to count everyting with a date 8/5 and prior, but I don't want to include the weekends.
 

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,416
To nerojr:

You should really start a new thread. The answer to your question is quite different. Take a look at the NETWORKDAYS function
 

Watch MrExcel Video

Forum statistics

Threads
1,133,275
Messages
5,657,786
Members
418,413
Latest member
Radoslaw Poprawski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top