| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function - counting based on criteria
I have a column of numbers. I need 3 formulas: (1) to count the numbers that
are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the rows in the column that are blank. Any assistance would be greatly appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function - counting based on criteria
=countif(A1:A100,"<=60")
=countif(A1:A100,"60") =countblank(A1:A100) "Candace" wrote: I have a column of numbers. I need 3 formulas: (1) to count the numbers that are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the rows in the column that are blank. Any assistance would be greatly appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function - counting based on criteria
Oops - the first formula ought to be one of these two
=sumprooduct(--(A1:A100<=60),--(A1:A100=1)) or =countif(A1:A100,"<=60")-countif(A1:A100,"<1") "Duke Carey" wrote: =countif(A1:A100,"<=60") =countif(A1:A100,"60") =countblank(A1:A100) "Candace" wrote: I have a column of numbers. I need 3 formulas: (1) to count the numbers that are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the rows in the column that are blank. Any assistance would be greatly appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
| Varying left criteria based on 1st Letter....If Function? | Excel Discussion (Misc queries) | |||
| Counting & Summing based on criteria on another column | Excel Discussion (Misc queries) | |||
| Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Linear Mode
