Seeking wisdom from experts in excel because I'm certainly not. I have a spreadsheet that principals in our district use to do teacher daily walkthroughs. (This spreadsheet is ongoing and will continue throughout the year. This data is populated and pulled into an ongoing spreadsheet of total percentages per domain.) By the grace of God, I have this part working correctly. (Well, maybe I am learning a bit about Excel) What I need, is a formula to take total walkthroughs per week for a specific principal and put in an ongoing table sheet per principal. (See examples)
Each week, the principals meet with higher administration to go over this document. Each week, (Example 2) should show their weekly walkthrough totals per principal.
The formula I've put in isn't working ;=COUNTIF(IMPORTRANGE("1icL7PmCVYwqmfFyaVGLHA02ANngrS9lIqgG6kbyyWo","SIV!b2:b300"), "Dana")
Dana is one of the principals.
To take this one step further, is it possible for me to go in each week and use the time stamps on example 1 to get a total for each principal walkthrough through a specific date?
I apologize for how confusing this sounds.
Bookmarks