I Have a problem right now. Here's the thing.
I' working on an Ms Excel. My data are the following:
Reg. No." Suggestion / Idea "Suggester's
Name/s" Emp.# Points Total Points
Now, I don't know what formula shall I used, on how to get the points on each suggesters based only on their ID # considering that some of them started submitting suggestions since 2009. Another also is that some of the suggestions are submitted by 2 suggesters. So i would like to know how it would appear on another sheet with these data: Name: ID # Year: Total POints( from previous 2006 year up to present) . I'm the one who enters the point. I don't know how to sum it up. Please help me