SUM calculations with multiple criteria

[NEHicks]

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

 

[David Biddulph]

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

 

[xlmate via OfficeKB.com]

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