| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"counting" number of entries
I'm trying to write a formula that will "count" the number of entries in a
list that are greater than one number but less than another. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"counting" number of entries
One way is
=COUNTIF(A1:A20,"="&C1)-COUNTIF(A1:A20,"="&D1) with lower limit in C1 and upper limit in D1 Another formula - =SUMPRODUCT(--(A1:A20=C1),--(A1:A20<D1)) "Roy Ringrose" wrote: I'm trying to write a formula that will "count" the number of entries in a list that are greater than one number but less than another. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"counting" number of entries
Hi,
If you are using 2007 then try: =COUNTIFS(A1:A10,"1",A1:A10,"<9") You can also use =SUMPRODUCT((A1:A101)*(A1:A10<9)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Roy Ringrose" wrote: I'm trying to write a formula that will "count" the number of entries in a list that are greater than one number but less than another. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Bug" in number format for long number entries? | Excel Discussion (Misc queries) | |||
| In Excel, show 0.00 for "zero" entries, but "-" if no entries | Excel Discussion (Misc queries) | |||
| Need formula for dividing by "number of entries" in a column or row | Excel Discussion (Misc queries) | |||
| Counting the number of "#N/A" errors | Excel Worksheet Functions | |||
| counting the number of times value of "x" appears in a row | Excel Discussion (Misc queries) | |||
Linear Mode
