Got it figured out.
I've changed:
=COUNTIF('Completed SRC Tasks'!$H$1111:$H$2222,A5)
To:
=COUNTIF('Completed SRC Tasks'!(INDIRECT("H"&D2)):(INDIRECT("H"&E2)),A5)
Which did NOT work as mentioned above.
Then I changed it to:
=COUNTIF(INDIRECT("'Completed SRC Tasks'!$H"&$D$2&":$H"&$E$2),A5)
And that works. Now to replicate this to all of my cells making different changes depending on what is being counted.
YES! This will help!
FYI that the &$D$2& references the cell D2 with my hypothetical 1111 value and the &$E$2 reference is for the E2 cell. Since I am copying these to other rows, without the $ in there, those values would change either up or down for the row or column to try to stay dynamic, so the $ holds them so that they are always referencing D2 and E2.
Just helping clear up the formula for those that may not know what the $ does.
Not that anyone who doesn't use Excel would even care, LOL.