If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need a fx for counting numbers between numbers (between 18 - 59
I am trying to have excel count numbers that fall between certain numbers.
I.e. all numbers in column B that range from 18-59 (that include the #18 and # 59). I have tried the COUNTIF fx but can only do "=18" and "=59" This ends up counting all numbers above 18 and all numbers below 59. I tried BETWEEN 18 AND 59 but I obvoiusly don't know the appropiate language. Thanks in advance. Jen |
#2
|
|||
|
|||
I need a fx for counting numbers between numbers (between 18 - 59
Try this:
=COUNTIF(B:B,"=18")-COUNTIF(B:B,"59") Better to use cells to hold the boundary values: D1 = 18 E1 = 59 =COUNTIF(B:B,"="&D1)-COUNTIF(B:B,""&E1) -- Biff Microsoft Excel MVP "Jen" wrote in message ... I am trying to have excel count numbers that fall between certain numbers. I.e. all numbers in column B that range from 18-59 (that include the #18 and # 59). I have tried the COUNTIF fx but can only do "=18" and "=59" This ends up counting all numbers above 18 and all numbers below 59. I tried BETWEEN 18 AND 59 but I obvoiusly don't know the appropiate language. Thanks in advance. Jen |
#3
|
|||
|
|||
I need a fx for counting numbers between numbers (between 18 - 59
Hi,
Personally I like =COUNTBETWEEN(18,59) Just kidding, I've asked Microsoft for a between function but no luck yet. In 2003: =SUMPRODUCT(B1:B100=18)*(B1:B100=59)) In 2007: =COUNTIFS(B1:B100,"=18",B1:B100,"=59") or you can replace the 18 and 59 with cell references, suppose A1 and A2 =COUNTIFS(B1:B100,"="&A1,B1:B100,"="&A2) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jen" wrote: I am trying to have excel count numbers that fall between certain numbers. I.e. all numbers in column B that range from 18-59 (that include the #18 and # 59). I have tried the COUNTIF fx but can only do "=18" and "=59" This ends up counting all numbers above 18 and all numbers below 59. I tried BETWEEN 18 AND 59 but I obvoiusly don't know the appropiate language. Thanks in advance. Jen |
Thread Tools | |
Display Modes | |
|
|