Hi,
Refer attached spreadsheet, cell H148.
Sumproduct formula. This formula works if I replace the range name Job_No with the actual range ie C9:C141.
However if I replace the range with the range name I get #NA error.
What is wrong?
I am also happy to use a SUMIF or SUMIFS formula for multiple criteria but I get #VALUE errors.
Hoping someone can help...
Regards,
Chris.
Bookmarks