| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula needed
I need to count the numbers in a range that fall equal to or more than one
number and equal to or less than one number |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif formula needed
Try it like this:
=COUNTIF(A1:A10,"=start_number")-COUNTIF(A1:A10,"stop_number") Start number = 10 Stop number = 20 =COUNTIF(A1:A10,"=10")-COUNTIF(A1:A10,"20") Or, if you use cells to hold the start/stop numbers: B1 = 10 B2 = 20 =COUNTIF(A1:A10,"="&B1)-COUNTIF(A1:A10,""&B2) -- Biff Microsoft Excel MVP "dmdodds" wrote in message ... I need to count the numbers in a range that fall equal to or more than one number and equal to or less than one number |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif formula needed
=COUNTIF(A2:A37,".7900")-COUNTIF(A2:A37,"<.7950")
This is what I tried and it is coming up with values that are not supposed to be included, there should only be one entry that fits the formula with these numbers. "T. Valko" wrote: Try it like this: =COUNTIF(A1:A10,"=start_number")-COUNTIF(A1:A10,"stop_number") Start number = 10 Stop number = 20 =COUNTIF(A1:A10,"=10")-COUNTIF(A1:A10,"20") Or, if you use cells to hold the start/stop numbers: B1 = 10 B2 = 20 =COUNTIF(A1:A10,"="&B1)-COUNTIF(A1:A10,""&B2) -- Biff Microsoft Excel MVP "dmdodds" wrote in message ... I need to count the numbers in a range that fall equal to or more than one number and equal to or less than one number |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif formula needed
Look again at the formula you were given, and correct yours accordingly.
Check the difference between , =, and < -- David Biddulph "dmdodds" wrote in message ... =COUNTIF(A2:A37,".7900")-COUNTIF(A2:A37,"<.7950") This is what I tried and it is coming up with values that are not supposed to be included, there should only be one entry that fits the formula with these numbers. "T. Valko" wrote: Try it like this: =COUNTIF(A1:A10,"=start_number")-COUNTIF(A1:A10,"stop_number") Start number = 10 Stop number = 20 =COUNTIF(A1:A10,"=10")-COUNTIF(A1:A10,"20") Or, if you use cells to hold the start/stop numbers: B1 = 10 B2 = 20 =COUNTIF(A1:A10,"="&B1)-COUNTIF(A1:A10,""&B2) -- Biff Microsoft Excel MVP "dmdodds" wrote in message ... I need to count the numbers in a range that fall equal to or more than one number and equal to or less than one number |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needed - is this possible? | Excel Discussion (Misc queries) | |||
| fomula help needed on countif | Excel Discussion (Misc queries) | |||
| CountIf Function Help Needed | Excel Worksheet Functions | |||
| Formula needed | Excel Worksheet Functions | |||
| Countif help needed | Excel Discussion (Misc queries) | |||
Linear Mode
