I'm trying to run a SUMIF across multiple sheets, and I'm having a hard time figuring out if I can and how. Here is the code I'm trying:


I tried to combine two different formulas to get that one, =SUM('First:Last'!AK200) and =SUMIF($F10:$F199,AK9,$G10:$H199) but is isn't working.

Can I do what I want? And if so, how?