=SUMIF(B:B,TODAY(),D:D)

--
__________________________________
HTH

Bob

"Shujjat Rasool" <Shujjat wrote in message
...
Hi.
I have a small excel 2007 file with 5 columns as S#, Date of Xmer damaged,
Expected date of completion, No. of Xmers repaired today. I want to
display
No. of Xmers repaired as per the date of today. I want to see the No. of
Xmers repaired each day i log in on my computer with current date i.e.
today.