| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel, how to count every 4th cell in column to see if occupied?
hello, i want to use a COUNTA function to count the occupied cells in each
column in an excel spreadsheet. However, the cells i want to count are every 4th cell & not the ones inbetween. i can use =COUNTA(c7,c11,c15,c19....) but my list size goes into to 1,000's & i only know how to enter the above formula mannually. I need to know how to write the function/formula to count every 4th cell automatically. i would be glad for anyone's help. thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
