I am a beginner at Excel . I have volunteered to keep track of the points accumu

Question

I am a beginner at Excel.

I have volunteered to keep track of the points accumulated for a Chicken breeders club. I had no idea that when I volunteered that they did not have anything already set up.

What I need seems simple enough but I just can't figure it out.

Here's the basic info....

A person earns points for the showing of poultry at various shows.

what i would like to do is take their total points per show and have them added together on a separate sheet.

on my main sheet i have:

A | B | C | D | E | F | G |

Exhibitor Name Event Breed Size Variety Award Total Points

I would like to focus on column (A) the name, and column (G) total points

on a separate sheet I would like to have a list of Exhibitors and their total cumulative points.

Im sorry if this seems simple but this is beyond my skills. I guess i learned my lesson about volunteering!

Can any one help? I've beeen working on this for two days and I'm now stuck.

thank you!!!!!

Explanation / Answer

I am assuming that an exhibitor may exist morer@ than once, and my guess is that there is not too many of them. So make a list of all the unique exhibitors on a second sheet. Start in A1 with Exhibitor Name, just like on the first sheet, and pout the names in A2, A3, etc. (Make sure they are spelled the exact same way as on the first sheet.) Now, in B2 (the first cell to contain the sum of points) enter this formula: =sumif(sheet1!A:A,"="&a1,sheet1!G:G) Fill the formula down for as many rows as needed.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.