I'm working on a spreadsheet that simply calculates totals across multiple worksheets. The tricky part is on the second worksheet (Attached). I'm trying to calculate all of the total goals for an employee over the course of a years span (april-march). The difficulty comes that I need criteria to validate a line of an employee, that way if for some reason they're not on the list of employees for a month, then the counts are still accurate. Is there a good way to do this?
Before this particular layout, I did it all in one worksheet, and used a simple SUMIF function to find the data. =SUMIF($A$4:$A$303,"=Emplo
yee 1",B$4:B$302). Now that I have it in multiple sheets (so that it prints and displays better), I'm having difficulty with that calculation. demo-cs.xlsx