SUMIFS formula to sum a range of cells if certain criteria are met

[roseme]

On the attached example spreadsheet, I am trying to use a SUMIFS formula in cell H6 to sum H18:H34 if A18=A6, and if H18:H34 is not blank. I am currently using the following formula:

Please Login or Register  to view this content.

The formula will not run properly and always comes up with #VALUE!. Any information that can be provided will be greatly appreciated.

Thank you.

[ben_hensel]

Since blank cells and text are ignored by SUM (and SUMIF and SUMIFS) in the first place, you can drop that second criterion because the function does it anyway. Easy!

I don't understand your first criteria.

The reason you're getting an error is because you're looking at a criterion range that is a different size than the summation range.

I think what you want is this:

Please Login or Register  to view this content.

[roseme]

I definitely over thought this one, thank you for setting me straight!