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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,271
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,271
To nerojr:

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

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,979
Messages
5,508,535
Members
408,688
Latest member
Bhojraj

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top