Question about Excel

[andersson1974]

is this the forum to post my question?

I'm a beginner at Excel, and I need help figuring out a function. (see below).

WEEK 1 2 3 4 5


Jack o o o o o

John o o x x o

Jane o o o o o


Persons with full attendance:

Key:
o = Present
x = Absent


I want to calculate the number of persons who have full attendance. If I had used Java (which I am more familiar with), I would use a nested "For" loop or something like that. But I just can't figure out a way to do this in Excel!

Are there any specific examples on the Net where I can refer to? I've tried searching, but to no avail.

Please do help!

[DukeDiablo]

Mr. Andersson-

Just a thought; however, could you possibly acheive your results in this manner?

Change X's and O's to 1's and 0's. More like a boolean test. Then sum each person's attendance "value." In your example, if the person has "full attendance," their attendance "value" would be "5." Anything less would not be full attendance.

Then by having Excel filter your attendance "value" results list,(what you want displayed below "Persons with full attendance:") it would only display those people with "full attendance."

Of course, then you would have to come up with a fancy way to autoupdate the maximum weeks figure at every iteration.

So maybe this plan isn't the best. Sorry, best of luck. Have a great week.

Oh and also check out the Microsoft Office website. They have tons of templates and tips for business users:

http://search.officeupdate.microsoft...llery/ct77.asp

That's a direct link to the "Staffing and Management" page. Please check out the other sections as well.

Specifically on that page, take a look at "Employee Absence Tracking." I think it looks like a pretty slick setup.

Best of luck and have a good one.

[DougL]

Hi

This link http://www.usd.edu/trio/tut/excel/ is an excellent site, you can e-mail your questions. i have had some good replies to my questions on excel.

Doug

[andersson1974]

thanks for the suggestion duke. As the spreadsheets I'm creating are meant for users who have relatively low experience with computers, I thought it was easier for them to relate to crosses and circles rather than Boolean values. but it was a good suggestion anyhow, thanks again!

oh and thanks for the great reference website doug! it helped alot!

[andersson1974]

I see you're using an ATI 8500 too duke, pretty problematic card ain't it?

[DukeDiablo]

Mr. Andersson-

Glad I could help...well I guess I didn't but nevertheless, I'm glad to hear that you are getting your system worked out.

Sorry I didn't get back sooner, I was gone all week.

As far as the Radeon 8500 goes, I haven't had the first problem with it. I bought it from www.newegg.com back in 2001 for 170 dollars. It originally a 230/230 clock; however, I have flashed the BIOS up to the retail level of 275/275 MHz.

The ONLY issue I have with the card is that while playing Aliens vs. Predator 2, some of the shading features are a little "sketchy."

Overall I'm very happy. I only wish I had waited a few months and saved a hundred dollars! haha.

Have a great week.