I need to essentially create a SUMPRODUCT IF function. That function does not exist in Excel.
In the attached spreadsheet, I'd want to sumproduct columns C and D if and only if the name in Column B wSUMPRODUCTIF.xlsas Garrett.
Any ideas?
Much appreciated.
Also, does anyone know how to apply headers to multiple worksheets?
Bookmarks