hi, once again i need some help with an excel formula. let me explain, its a lunch sheet where employees sign in every time they have lunch for everyday, then a seperate sheet that records the employees who ate lunch for all the days of the month. is there a way i can put in an X symbol in sheet one such that it can be seen in sheet 2 and then adds up all the Xs in the sheet 2. please look at the attachment to help understand. thanks

Edited by: finad on 03.17.04.

Greetings,

If your data input table is as simple as represented in your attachment (even if it isn't), have you considered utilizing a simple pivot table to accomplish what you are looking for? You can use the grouping function within the pivot to lay out by days / months / quarters.

See the attached.

Hope this helps and please let me know if you have any questions.

Regards,


Mac

Hello finad,

Received your PM and thought I'd post my response back to your original thread (it's best practice around here to keep the threads going) this allows all members / guests who might have the same question to get responses to the questions that are asked (it is how we all learn). Additionally, you may find that you get multiple approaches to solve the question / problem you posted. You could miss out on some really good solutions that way.

Anyway, in your PM you asked me to describe pivot tables in more detail as you aren't very familiar with them. I do a lot of analysis in my work and find them to be an invaluable tool in "slicing and dicing data". They are very flexible and fairly easy to work with once you get the hang of them.

I have to leave in a moment for the office and won't do justice to any detailed explanation I might try to give in the next few minutes. Let me suggest that you do a search on this site for "pivot tables" (see what posts you find). You can also go into excel help and type pivot tables in the search area.

Otherwise, keep watching this thread. I'm sure as other members "awake" or get home from work, they will do everything they can to help you (they always have done so for me). If I have time at the office later and you haven't received any helpful responses I'll try to post something more helpful.

I hope I haven't offended you in any way by replying back to your original thread. You'll find (in almost all cases) that you will learn more and get more favorable results by doing so.

Welcome to UA, keep coming back! If it weren't for the time constraint I'd attempt to post some other examples and further details.

Best regards,


Mac

In regards to pivot tables, check out NateO's links in this thread.

http://www.utteraccess.com/forums/showflat...;o=&fpart=1

Eric

hello,
this is a very similar question to the one you have posted and I have answered here .

I added your wish into the original sheet and I attach it.

Hope this helps

Martin

thanks heaps will read through the pivot tables. they are kinda hard to use especially if you dint even know they existed but tanks all for enormous help!!!