Thanks for the chance to pick your brain for a bit. I have been tasked with creating a sheet that helps track employees trained in CPR, their expirations, and a ratio of total employees PER SHIFT to CPR certified employees PER SHIFT.
I figured =COUNTIFS would be my best bet but I have ramming my head into a wall trying to figure it out. Hopefully it is something small ( I am new to excell's formulas) My formula is as follows: =COUNTIFS(Table4[Shift],"='CPR Tracker'!H1",'CPR Tracker'!K:K,">=3")
Capture.PNG
Any assistance would be greatly appreciated, also if you see a quicker easier way to do this... and it's no extra trouble, please share!
Thank you!
Bookmarks