Forum Discussion
Solved
Timesheet Tracker Help with INDEX/COUNT/SUM functions or alternative
Hi! I have inherited a series of timesheet trackers that I'm hoping to identify a formula or solution to easily quantify the PTO classifications that an individual employee took throughout a year. I...
Lets try the following formula-
=SUM(--(LET(x,VSTACK('7.15:8.26'!$B$6:$B$44),y,VSTACK('7.15:8.26'!$C$6:$Q$44),FILTER(y,x=$D2))=E$1))
Lets try the following formula-
=SUM(--(LET(x,VSTACK('7.15:8.26'!$B$6:$B$44),y,VSTACK('7.15:8.26'!$C$6:$Q$44),FILTER(y,x=$D2))=E$1))
Thank you for this! It's working like a charm so far, outside of some minor data clean-up I need to address on my end to remove inaccuracies. Really appreciate your help!!
