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:
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.
Bookmarks