Thread: How do I write a formula to tally class participation

Originally Posted by TMShucks

It's not the forum's policy to do your homework for you.

Have a look at COUNTIF or COUNTIFS (in 2007) or SUMPRODUCT (2003)


Regards, TMS

LOL. Sorry it sounds like homework.

I am the secretary for a regional slot car racing club. We race at 9 different commercial tracks in the Carolinas. I built an excel file to tally individual race points and payout for the season. Each driver designates a "home" track and that track gets a point every time that driver enters a race event. The track with the most participation will be awarded the "championship race" - a benifit to the track that helps promote the club, since they make money when we visit.
I felt it was easier to get my point accross using the "speech class" scenario.

Guy

Originally Posted by dilipandey

Hi gr8rcfan,

I would suggest you to upload a sample workbook with dummy results. Click on "go advanced" while replying and look for paper clip icon to upload the sample file.

Regards,
DILIPandey

<click on below 'star' if this helps>

Thank you, DILIPandey

I have attached a sample workbook as you suggested.

Speech.xls

The "Speech Competitions" tab shows the students appearing at each month's event
The "School Students" tab show what school each student comes from
The "School Points" tab shows each school (represented by a number) with the cells blow to be used to show the tally.

Thank you for any help you can provide

Guy

Hi, DILIPandey

I think you may have missed my earlier replies. I am not a student. I've developed an extensive file for a non-profit organization, and wanted to expand it's capabilities to I can better support that organization. However, I mustn't post my origional file here because of privacy. Please help me with my hypothetical scenario. The formulas you apply will help me learn how to improve my worksheet.

Thanks again.

Guy

Thank you, DILIPandey

My reference to "student" was only to re-direct the moderator's comment about the forum's policy of not doing my homework for me. Having been in the computer repair and IT fields for the Government and the Air Force since 1972, spanning the range from Vacuum Tubes to VSLI circuits, I certainly realize that every day is a learning experience. However, the spreadsheet "School Rank.xlsx" you pasted in post #6 was virtually blank, and I could not learn anything from it to apply to my spreadsheet. I'd spent a great deal of time, trying to discover a solution to my question. I was just hoping someone at excelforum.com could help.

Cordially,
Guy

Hi, Haseeb A

The object: Devise a formula so that every time a student competes at a monthly competition, their school gets a point.

Referring to the file "speech.xls:

The "Speech Competitions" tab shows the students appearing at each month's event
The "School Students" tab show what school each student comes from
The "School Points" tab shows each school (represented by a number) with the cells below to be used to show the tally for that school.

Thanks in advance,

Guy

Thank you, Haseeb A

Your formula meets my needs perfectly. I appreciate the built-in flexibility and explanation. With a little study, I should be able to understand and apply to my club's spreadsheet.

Thanks again,

Guy