This is so much fun....
I've changed:
=COUNTIF('Completed SRC Tasks'!$H$1111:$H$2222,A5)
To:
=COUNTIF('Completed SRC Tasks'!(INDIRECT("H"&D2)):(INDIRECT("H"&E2)),A5)
Here D2 and E2 have the values 1111 and 2222 respectively. I still get an error that the formula isn't valid.
Oh, and A5 references the string (one of my tech's names) that gets counted on the "Completed SRC Tasks" worksheet with the raw data.
I'll get it yet, but need people to stop bugging me at work so that I can mess with it for more than about a minute at a time.
