Hi, I am trying to put together a "Workbook" in my 2003 Excel. I have one sheet with the TOTAL sorted by Race and Living Situation.

Then I have the sites Totals... that I connected to the TOTAL.

Now I am trying to make a "everyday" use sheet... where the worker enters Example AA for African American and then it connects to the Sites Total page and adds there... and then connects to the TOTAL page and so on... the number will continue to rise...

Is this possible? I can't figure out how to do it...

Yes, see attached sheet. Pressing help when the formula is selected will explain how it works. Any problems, we're here to help

I'm having trouble understand what you want. Are you trying to get a total by site and then grand total of each ethnicity on a daily basis? Or what?

Sorry it was vague... Ok let me think of how to explain better...

I have 3 Sheets in my Work Book. I kind of worked backwards...

Sheet #3- Grand Total for all ethnicities. Separated by Race...
1 -African American,
2- German,
3- Hawaiian, etc.. for all centers combined...

Sheet #2 - Grand Total for one center ( might not be adding another center)

Sheet 3 and 2 I would like to "Lock" so the workers can't mess with those... the numbers will just change as a result of adding clients to Sheet #1

Sheet #1 - The workers will be using this sheet constantly. Adding the information.. Example... Question of Ethnicity... The person they are entering is Hawaiian... so they would type HI or the number 3 and it would automatically calculate from that cell to the Sheet #2... and then Sheet #2 updates sheet #3... I have Sheet #2 and #3 connecting already.. but it is the joining of sheet #1 in there that I am wondering if it is possible.

So in the end if on Sheet #1 I have 4 Different Clients listed as being Hawaiian, 2 Clients German and 1 African American then on the Sheet #2 and #3 it will have 4 Hawaiian, 2 German, and 1 African American... automatically...

Was this clearer? =)

This would actually be better done in a database. Do you have Office Pro?

On Sheet #1 are they just going to add people line by line?

Yes they will just be adding people line by line. Is this just super crazy to even try to attempt? =) Be truthful.. hehe..

No its not, nor is it too difficult, though its harder in Excel then it would be in Access. So I ask again, do you have Office Pro with Access?

I do have ACCESSbut I am unfamiliar with it. I have not had a need to use it. I should go play with it and see what I can get...

As I said, this would be VERY easy in Access. You could create a table:

tblDailyClients
DailyClientID (Primary Key Autonumber)
EthnicID (Foreign Key)
LogDate

You would also have a lookup table:

tluEthnic
EthnicID (PK Autonumber)
Ethnicity

Now you would create a form where there date is filled in automatically by setting its default value to Date(). The user then choose Ethnicity from a drop down list.

Finally you would have a report that is grouped by Day and Ethnicity with a count for each grouping.

Even without Access knowledge, you could put this together in less than an hour.

Thank you, I will try it in Access and I'll write back after (or during if I run into a problem) and let you know how it is going =) YOU GUYS ARE SOOO HELPFUL!!

You can simply use the count if function in excel

on sheet 2 in the cell where you want the total of Hawaiin people for instance type the following formula
=COUNTIF(Sheet1!B:B,"HI")
where Sheet1!B:B = the column on sheet 1 where you typed the HI for Hawaiin - change this column in the formula to the one you actually have the HI in

You repeat this for all the ethnic groups in their different cells and change the "HI" to whatever your indicator for that ethnic group is

Hope this help
Please let me know

Ah... this is around the line of what I started thinking of... the =IF factor. I have recently accepted a job elsewhere and tomorrow (Friday May 18) is my last day here so I will do what I can with this and then someone else can take it.

I really appreciate everyone's answers, I tried meddling with the ACCESS but I couldn't figure it out, hehe... But thank you so much... Can I put a "chain" of IF factors? Like =IF(cell = HI then connect to this other cell)?