Free Microsoft Excel 2013 Quick Reference

Excel to COUNTIF if number greater than one but less than another

I'm using COUNTIF for a column of 320 numbers that range from 1 to 35. I am
trying to have 3 running totals. I'm having difficulty with the middle

The first 2 seem to be working -
1. The number of instances where the entry is less than or equal to 3.

2. The number of instances where the entry is greater than 7.

I can't figure out the equation for greater than 3 but less than or equal to

Post your answer or comment

comments powered by Disqus
Hi guys, I have a range where I need to find the occurance of a number
greater than 10500 but less than 13500 and I think it should look like
this: =countif(d5:d3200,>10500,

Hi guys, I have a range where I need to find the occurance of a number
greater than 10500 but less than 13500 and I think it should look like
this: =countif(d5:d3200,>10500,<13500) would that be right as far as
syntax etc? Also how would I copy this formula through multiple
worksheets (one workbook, whereby the formula moves down 1200 cells
continuously to the end of the worksheet and hopefully replicates in
the same spots in ultiple worksheets to the end of the workbook? The
cell references remain relative throughout. As always I appreciate any
help you can give me. Thanks!! steveo It shouldn't make any difference
but this is excel 2004 mac.

I have a list of numbers ranging from 2 to 5,000. I need a count of how many
are greater than 50, but less than 250. I would also need a sum once that is
figured out. I've tried everything. This is Excel in Windows XP.

Hello...this is hopefully something very easy for one of you experts to answer for me:

I am in need of 2 different formulas.

1. Counting the numbers in Column A that are greater than 60, but less than 90.

2. Give me the sum of the amounts in column B, when it sees a number in column A that is greater than 60, but less than 90.

Please help if you can!! greatly appreciated!

Can anyone tell me how to write a formula that evaluates whether the contents of a cell are greater than X but less than or equal to Y and return one value if true and another if false?

Thank you in advance!!

Hello there,

I am trying to get this function to work and can't quite seem to get it to work properly. My goal is to find cells in row 96 that are greater than 0 and less than 8 then subtract the total from 8 to get a negative number...i.e. if the cell holds 7 then the outcome would be -1.

What I've tried is this:


But the outcome of the calculation is 0 even though I know it should be -1.5. I can get it to work with this function =IF(J96<8,(J96-8),0) But then all the cells that do have 0 in them, add a -8 as my outcome. I don't want that -8. I want anything that would be from -7.99-0 Make sense?


I need to display text/number from a row in a column that corresponds to the lowest positive number greater than zero contained in another column.

My info. is in C6:C60, D6:D60, E6:E60, F6:F60, G6:60.
Column G6:G60 contains both negative & positive numbers.
Column C6:C60 contains rail car text/numbers that I want to display (this rail car number) the only one that corresponds to the lowest postive number greater than zero found in Column G6:G60.

All other other columns contain fixed original numbers (weights) I do not need to check or display.

I would like to accomplish this either by formula or by macro displayed in a cell(s) same worksheet but aside from these columns. Thanks.

I need to count the number of occurances between 2 values.
How many cells' values are greater than 1000 but less than 1500
How many cells' values are greater than 950 but less than 1000

I can use =COUNTIF(T2:T90,">1000") but how to then say and less than 1500.

I know it's probably very simple, but I can't find a list of criteria examples.



What formulea do I use to find a the number of cells with a value greater
than 20 but less than 30 in a range of cells B2:B32 in Excel 2002
Countif(B2:B32,"<=30")- countif(B2:B32,"<=19")
Is there an easier way to write this?
Can the lower and upper limits be set in refrence cells? say H20 and H21

Don't want to sound silly here, but I am actually having a problem with a formula that will allow me to count only values greater than 0 but less than 11. Is this Possible in 1 unique formula? Heres the situation:

Within Column B6:B35, I want a count of any number that is greater than 0 but less than 11. I tried the following but it returns a 0 although I have 3 values within that range:


Thanks In Advance for any help here...

I had posted this question earlier, but had not worded it as a count formula.
What I want to do is count in a column numbers greater than 13 but less than 20.
I am also trying to write another formula that counts numbers equal to or higher than 1 but less than 12. In other words, I do not want this count to include any cells that contain 0.

Thank for you help in advance.

I'm pretty new to excel and am looking for some help. I want to do just what my topic title says. If I sell 5 computers and sold a service plan on four of them i want to figure out what my attach % is. i put the cost of the computers in one column(500,400,650,720,500); and the cost of the service plan that was sold in the next column(120,80,150,0,120). the fourth pc had no service plan sold so it's a 0. i want to count how many cells in the service plan column have a number greater than 0 and divide it by how many computers were sold (the number of cells in the computer column containing a number. Thanks.

Hi All,

I'm trying to create a multiple IF statement that incorporates a smaller than or equal to /greater than function, and it's got me stumped!

Column A contains numbers. In the second column, I need to say that if the number in column A is greater than 0 but smaller than or equal to 500 it should be "Green", if it's greater than 500 but smaller than or equal to 5000 it should be "Orange" and if it's greater than 5000 is should be "Blue".

Please help, Excel wizards!

For example I want D5 to change its color or give a warning if D6 has a number greater than 5. Can anyone come up with a formula for that.

How do you make a formula to state if a number is greater than one number but
less than another number. My example is: if d10 is greater than b20 but less
than b20+1, then b10, if not, b20.

i have a row full of dates and i need to check if any of the dates are less than a year away from the current date. i created a cell with the current date and have been trying you use a combination of an if statement, a days360 statement and a countif statement to have the cell show up as either "ok" or "expiring soon". i dont need to know how many just if at least one is less than a year from the current date.

here is the formula i have now.
=IF(DAYS360(GO2,COUNTIF(G2:FG2,))<360,"Expiring Soon","ok")

GO2 is the cell with the current date
G2:FG2 is the range of cells of dates that i need to check. (this range has blank cells in it)

not sure if the count if part makes sense but with it i at least get one of the 2 values back instead of an error. I used it for another formula like this and even though i wasnt counting the number it still works

Any one have any ideas?

I'm trying to write a macro in Excel that would change any number greater than 10 in a spreadsheet to say "+10"

Please let me know. Thanks.

I have a spread sheet that has various fields like name of person taking
call, name of person calling in, their account number, their order number
etc. I would like to be able to have a search function in Excel to look up
by more than one of these criteria, like order number and name of person
calling in - or any combination I might want without being case specific. I
would like to pull up as many possiblilties as possible but limited to the
criteria put in to search by.

Hi All,

As far as I understand the standard Bin2Dec and Dec2Bin functions can only
handle 10 character binary numbers.

Does anyone have any pointers on how to handle binary numbers greater than

If I have completely mis-understood how excel handles binary numbers feel
free to let me know.


I have problem, and follow the instructions in old post that might be similar to my need but doesn't have result in my workbook. Is there other operations, like save after put the formula into code area? And if you know if this instruction is valid for my specific need:
I need excel to generate increasing number in every one random empty cell. When I type digit "1" for the first entry I want it to calculate next progressive number for every other cell in random order which I choose and type "1"
Thanks in advance
Best regards

I am trying to write a formula that says if numbers in a column are greater than 13 but less than 20. I can't seem to figure it out. Can someone help me?

Actually I am trying to say countif numbers in column are greater than 13 but less than 20. sorry for the confusion.

Is there a way for Word to recognize a list that begins at a number larger than 1? If I begin a list with the number 1 Word will automatically indent and begin the list, and properly start the next number in the sequence once I hit enter. However, if I start at a number greater than 1 Word will not recognize this, even if I highlight the list I am trying to create and apply numbering from the paragraph menu. I am using word 2010, please see the image below for a clear illustrate

Hey all,

Thanks for being so helpful on these forums, I am learning a lot. I have a question using match / index or vlookup to pull data from one worksheet to another. Take a look at the attached example it will hopefully make my explanation a bit more clear.

I have an input page where coworkers will input weights into column C as to what data they want to consider. What I want is for only the Metrics that are marked with a value >0 to be reflected in the output page. I figured out how to do this with the first metric marked with a value greater than 0, but I am struggling to figure out the remainder.

A few notes to keep in mind, I can't sort the data or use VBA (my boss lives in the dark ages and doesn't "trust them"). Also, I have a ton of data and metrics so I want something that is computationally not too intense. For that reason I am trying my best to avoid arrays or the indirect function.

Any help would be much appreciated.



I am trying to return the row number of the first cell in column 'H' that contains a number greater than 0.

I have tried using the the MATCH function but I'm not sure how to ask for a number greater than zero.

Furthermore, I need to look in a certain range in column H (ie. rows 5 to 15).

Is this possible?

Thanks for anyone that can help


No luck finding an answer? You could always try Google.