Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to count cells containing #'s in a specific range
I know this is going to be an easy answer nut I just cant figure it out...
How do I count a cell that is greater than a specific and less than a another specific number....or to count it if it contains a number in a specific range? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to count cells containing #'s in a specific range
Use COUNTIF():
=COUNTIF(A1:A10,"3")-COUNTIF(A1:A10,"7") will count the number of cells with value greater than 3 and less than 7 -- Gary's Student "woogiebooboo" wrote: I know this is going to be an easy answer nut I just cant figure it out... How do I count a cell that is greater than a specific and less than a another specific number....or to count it if it contains a number in a specific range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
How do I create formula to count numbers in a range of cells? | Excel Worksheet Functions |