Can you clarify when you say nighshift changes? Perhaps give a worked
example.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"eknath" wrote in message
...
i have to create daily report in which present ,absent, night shift people
to
be counted i am using sumproduct but for another day nightshift changes
den
previous days report changes please help me