I have a work a spreadsheet that contains several columns for the number of campers, their pets, and vehicles that are checked in every day. What I need is to be able to add up all the campers for a month that have stayed. So if today is Saturday and I have 10 people in the campground the total for that day is 10. On Sunday, 2 campers leave so now I have 8. Later in th day 3 campers check in so now I'm back up to 11 campers total for the day even though they are not all in the campground at anyone time. I need to be able to take the total from the day and store it somewhere or find a way that I can use the same sheet for multiple days. So that on Mon I can enter the number of campers in a cell that show how many were there and then on Tues, using the same sheet but for a different day show the total for Tues but add the amount of campers from Monday and Tuesday together. I know I will be counting some campers twice or even more times as some campers will be there on many days. So how can I write something that will give me the total for the month, but won't subtract the ones that have left? Larry Sometimes I think I understand everything, then I regain consciousness

I think what you need is some hospitality software. Forget EXCEL. What you have is like a hotel. A hotel-motel package will give you total campers by day, total number of different campers by period, total number of new campers by day, etc. There are a few free or reasonable cost programs available that should suit your needs. Most of them have daily reports that would supply your answers. Also this can do reservations and billing.

I agree. But I work for a County. We can't get any outside software. I have to use Excel or just do the repors with a calculator. Sometimes I think I understand everything, then I regain consciousness

I've not had time to study your requirement in detail however it seems to me that you would be better to not use 'days' as such but rather add some columns that record each camper's 'date of arrival' and 'date of leaving ' using date formatted cells. Assumption is that each camper, pet etc is in a separate row. The end of month report could total all the campers you've had on site by counting the instances of arrival date and it could also report all the campers who have no date of leaving entered i.e they are still onsite. If you really want the 'day' as well you can format a cell to provide it by typing =TEXT(B2,"DDDD") where B2 is a cell containing a date like 14/03/07 You could do all this on one sheet and a 'sum' cell (e.g = COUNT(A1:A1000)) covering a big enough selection would keep your running total up to date . If you're not totally confused , you don't fully understand the question.

The Count function looks like what I need. I don't use the day at all. We have column that totals the number of people we have at anyone time. If someone leaves, the amount shouldn't go down only up if some one else checks in. I had no idea what function to look uder. Sounds like Count will do it. Thanks. Sometimes I think I understand everything, then I regain consciousness