ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to keep a running tally of boxes filled with info (https://www.excelbanter.com/excel-worksheet-functions/186598-how-keep-running-tally-boxes-filled-info.html)

fireman175

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!

Carl Henthorn

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!



All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com