Convert SUMIFS formula to SUMPRODUCT

Originally Posted by boopathiraja

Hi, Del the error values, in Register from row13 to 21 the formula will work

Thanks! That works, and makes sense. I changed the formula in the register to it doesn't return error values. I'll explain below should it be of any benefit to someone finding this thread.

The error values were a result of the sheet referencing a lookup, but since the reference field was blank it returned error values. So I changed the formula in the register sheet to return blanks if the reference is blank and that removed the errors. (The reference field being column "D"). I changed the lookup to be =IF(D79<>"",VLOOKUP(D79,Category,4,FALSE),"")


Thank you both for your help!