Thread
:
Index not Reurn the correct Result
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
Posts: n/a
Index not Reurn the correct Result
John wrote...
Thanks Harlan for your guidance, problem now is it returns a #N/A value.
....
What does the formula
=SUMPRODUCT((Date_HoursWorked=H$9)*(StaffNo_HoursW orked=$B$13))
return?
Reply With Quote