I designed a formula: =SUM(($E$1:$E$49, "")*($G$1:$G$49, "5A")) This worked
at first, but when I increased the range size from 49 to 258 it won't work
now. I have checked my formatting and can't come up with an answer. I am
trying to find the # of blank cells in column E by unit - column G - (5A,
etc) for a large range. Any help would be appreciated.

Thanks