Hi,
I'm trying to calculate the number of cells in a range that are greater or equal than 36 but less than or equal to 48.
Here's what I have:
=COUNTIF(J2:J312,">36,<48")
It keeps returning a value of 0.
Can someone please help.
Thx.
Hi,
I'm trying to calculate the number of cells in a range that are greater or equal than 36 but less than or equal to 48.
Here's what I have:
=COUNTIF(J2:J312,">36,<48")
It keeps returning a value of 0.
Can someone please help.
Thx.
Last edited by mbhim; 02-24-2012 at 01:17 PM.
Try:
=COUNTIFS(J2:J312,">=36",J2:J312,"<=48")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
mbhim,
Welcome to the forum!
I see you have Excel 2007 listed as your MS Office version. In that case, you can use CountIfs:
=COUNTIFS(J2:J312,">=36",J2:J312,"<=48")
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you! That worked.... I do have another question though. I now have to add another condition - calculate the number of cells in a range that are greater or equal than 36 but less than or equal to 48, and that answer "yes" in another column.
ie.
Age Yes/No
59 No
36 Yes
59 No
59 No
52 Yes
59 No
13 Yes
58 No
48 Yes
57 No
37 Yes
57 No
41 Yes
57 No
37 No
57 No
57 No
57 No
Any ideas?
COUNTIFS allows multiple conditions so with Yes/No in column K you can change the prviously suggested formula as follows
=COUNTIFS(J2:J312,">=36",J2:J312,"<=48",K2:K312,"Yes")
Audere est facere
That worked! Thank you so much!! You've saved me so much time!!!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks