I have 2 WS, The first 1 I update regularly the second 1 is my monthly summary.

I use countif in WeeklySummary to tally the am & pm, the formula I have is =IF(A:A="permanent", COUNTIF(B:B,"am"))

"am" that is permanent
"am" that is temporary
"pm" that is permanent
"pm" that is temporary

Thanks in advance for any help ☺