Greetings everyone!
I have a somewhat convoluted counting situation in which I normally use SUMPRODUCT (thanks, Excel Forum, for the education!), but in this case I maybe need to do an INDEX/MATCH-type function across sheets. It could be an array.
Specifically, I need to count the number of a particular grade (A-E) that's in C:C on the Evaluations sheet (whole sheet included). There's also a date in D:D on that sheet.
Then what I need to do is reference the report serial (B:B) on the Evaluations sheet and match it with the serial (B:B) on the Reports sheet. Then I need the formula to look at the Department in A:A on the Reports sheet.
Finally, I need a count by grade (B:B through F:F) by department (in A3:A10) by month (A1) on the Departments sheet (that's the report I need to run from the data on the Reports and Evaluations sheets).
Hopefully that makes sense. TL;DR: count grades by Department by month across two sheets, and placing a report on a third.
I greatly appreciate everyone's assistance. Thanks again!
Bookmarks