How do I write a formula to tally class participation

[gr8rcfan]

A high school district conducts monthly speech competitions

The school district has 8 schools

Each school has a speech class with various numbers of students who compete at various monthly competitions.

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

[TMS]

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

[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>

[gr8rcfan]

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

[gr8rcfan]

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

[dilipandey]

Hi gr8rcfan,

Honoring suggestions provided by seniors will make you learn as well. Choice is yours ...
By the way, I have given a try to your spreadsheet and attached that back for you to review. Feel free to get back in case you stuck somewhere.

Happy learning

Cheers...

Regards,
DILIPandey

<click on below 'star' if this helps>

[gr8rcfan]

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

[dilipandey]

You are welcome Guy . . .

Cheers . .

Just wanted to share that though I am a MVP in Excel, having around 8 years of experience in working n developing with Excel but I assume myself to be a student so that my learning never stops and let me admit that I am proud to be an student . . .

Regards,
DILIPandey

< click on below 'star' if this helps >

[gr8rcfan]

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

[Haseeb Avarakkan]

Hello gr8rcfan,

In your sample there are 3 sheets. On 1st tab contains multiple months, 2nd tab contains some students in each school. so how do you want to calculate the points?

Can you please update your sample with desired results & kindly please explain how did you get those results? So the members can easily figure out.

[gr8rcfan]

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

[Haseeb Avarakkan]

Create a 2 column table, 1st col enter school codes & 2nd col enter the corresponding school names. See the attached.

It is finally looking 100 rows in 2nd tab, if you add more students in 2nd tab correspondent school points will update.

Does this help?

[gr8rcfan]

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