Hi Everyone,
I have this formula which is not working, can anyone please ftell me what i
am doing wrong:

=IF(B119TODAY(),"",SUMPRODUCT(--('Punch Clock'!$A$3="Roderick
Spiteri"),--('Punch Clock'!$A$4="Morning"),--('Punch Clock'!$A$1=B119),'Punch
Clock'!$B$1))

Thank you
Albert

In what way is it not working?

The syntax is correct

If there is a time in B119 you will need to format the result cell as HH:MM
to get the same result

edvwvw

albertmb wrote:
Hi Everyone,
I have this formula which is not working, can anyone please ftell me what i
am doing wrong:

=IF(B119TODAY(),"",SUMPRODUCT(--('Punch Clock'!$A$3="Roderick
Spiteri"),--('Punch Clock'!$A$4="Morning"),--('Punch Clock'!$A$1=B119),'Punch
Clock'!$B$1))

Thank you
Albert

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200904/1

Thanks for your responce and I apologise for my delay. In Cell B119 I have a
date, but my problem is that the result I am getting is 00:00:00, when it
should be the time which is in 'Punch Clock'!$B$1, so I am getting a result
but the wrong one.

Thank you once again
Albert


"edvwvw via OfficeKB.com" wrote:

In what way is it not working?

The syntax is correct

If there is a time in B119 you will need to format the result cell as HH:MM
to get the same result

edvwvw

albertmb wrote:
Hi Everyone,
I have this formula which is not working, can anyone please ftell me what i
am doing wrong:

=IF(B119TODAY(),"",SUMPRODUCT(--('Punch Clock'!$A$3="Roderick
Spiteri"),--('Punch Clock'!$A$4="Morning"),--('Punch Clock'!$A$1=B119),'Punch
Clock'!$B$1))

Thank you
Albert

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200904/1