ExcelBanter - SUMPRODUCT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMPRODUCT (https://www.excelbanter.com/excel-discussion-misc-queries/231326-sumproduct.html)

ColleenK

SUMPRODUCT

Hi,

I am new to using the sumproduct formula, would someone be able to tell why
the following is not working:

=SUMPRODUCT('Detail Hours'!A1:A60000=A9)*('Detail
Hours'!A1:A60000<"")*('Detail Hours'!H1:H60000)

Thanks
--
CK

All times are GMT +1. The time now is 07:52 AM.