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

Did you intend to use SUMPRODUCT?
And did you intend = instead of the commas?
--
David Biddulph

"NEHicks" wrote in message
...
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

NEHicks wrote:
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

Try the SUMIF formula since you have one criteria which is 5A

HTH

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1