A
albertmb
Hi Everyone,
I have this formula which is not working, can anyone please ftell me what i
am doing wrong:
=IF(B119>TODAY(),"",SUMPRODUCT(--('Punch Clock'!$A$3="Roderick
Spiteri"),--('Punch Clock'!$A$4="Morning"),--('Punch Clock'!$A$1=B119),'Punch
Clock'!$B$1))
Thank you
Albert
I have this formula which is not working, can anyone please ftell me what i
am doing wrong:
=IF(B119>TODAY(),"",SUMPRODUCT(--('Punch Clock'!$A$3="Roderick
Spiteri"),--('Punch Clock'!$A$4="Morning"),--('Punch Clock'!$A$1=B119),'Punch
Clock'!$B$1))
Thank you
Albert