Sumproduct function
Hi,
In an attendance sheet, I need to calculate the number of fridays that each
employee has worked. Each cell captures either a text value (a combination of
X, M, S, A etc) or a numeral.
I'm trying to use the sumproduct function to do this:
Range E9:AI9 contains the calculated Fridays (using the weekday function)
Range E11: AI11 contains the attendance data
=sumproduct(--(E9:AI9="Fri"),(e11:ai110)
The formula gives the number of times "Fri" appears, but not the number of
times the relevant cell contains a numeric value.
Can you please help me??
Thanks
|