When I use the following formula, I get the answer I want (totaling of all
cells which indicate an individual was age 21 or over at time of admission).
However, when I attempt to get the opposite outcome (total of all cells which
indicate an individual was under age 21 at time of admission), I end up with
an outcome that merely counts the number of cells between G4:G5000. I don't
get why it works one way, and merely reversing the "" sign won't work.
Clearly the first formula is only counting those 21 or over, while the second
formula seems to be looking at all blank cells (which is why the value I
obtain is 4996). HELP! Thanks, Dan

=SUMPRODUCT(--('ASAP Database'!$G$4:$G$500021))-This formula works

=SUMPRODUCT(--('ASAP Database'!$G$4:$G$5000<21))-This formula doesn't work