Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to keep a running tally of boxes filled with info
Hi, I use a spreadsheet of Excell 2007 to keep track of dates that different
individuals work. There are about 150 persons and everytime they work a day, I put the date in the next sequencial box to the right of their name. I need to keep a running total of the total number of boxes filled in. Any suggestion on how to do this? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to keep a running tally of boxes filled with info
try using COUNTA() function to map out the area that the boxes may be
poopualted in, it will tell you how many feilds have values in them "fireman175" wrote: Hi, I use a spreadsheet of Excell 2007 to keep track of dates that different individuals work. There are about 150 persons and everytime they work a day, I put the date in the next sequencial box to the right of their name. I need to keep a running total of the total number of boxes filled in. Any suggestion on how to do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference error when trying to keep a "running Tally" | Excel Discussion (Misc queries) | |||
filled boxes with patterns dont print | Excel Discussion (Misc queries) | |||
formula to keep a running tally of the number of times a certain w | Excel Discussion (Misc queries) | |||
How do I tally checked check boxes in an Excel spreadsheet? | Excel Worksheet Functions | |||
How Excel 2003 Highlight random cells and running tally appear? | Excel Discussion (Misc queries) |