Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm using the following formula, but have to add the number lines manually. I
know there has to be a formula to ease my burden. =COUNTIF(B$2:B1199,(1)), one being #1, =COUNTIF(B$2:B1199,(2)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make the record count always show when using filters... | Excel Discussion (Misc queries) | |||
Make a count based on Drop Down Option | Excel Worksheet Functions | |||
How to make COUNT indicate ROW | Excel Discussion (Misc queries) | |||
Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
how do I make a function to count days? | Excel Worksheet Functions |