software

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

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;eknathquot; gt; wrote in message
...
gt; i have to create daily report in which present ,absent, night shift people
to
gt; be counted i am using sumproduct but for another day nightshift changes
den
gt; previous days report changes please help me
shif changes after every saturdayquot;Bob Phillipsquot; wrote:

gt; Can you clarify when you say nighshift changes? Perhaps give a worked
gt; example.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;eknathquot; gt; wrote in message
gt; ...
gt; gt; i have to create daily report in which present ,absent, night shift people
gt; to
gt; gt; be counted i am using sumproduct but for another day nightshift changes
gt; den
gt; gt; previous days report changes please help me
gt;
gt;
gt;

Then you will need to capture the shift in a cell(s) on the worksheet and
use that in the SP formula, and update the cell when the shift changes.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;eknathquot; gt; wrote in message
...
gt; shif changes after every saturday
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Can you clarify when you say nighshift changes? Perhaps give a worked
gt; gt; example.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;eknathquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; i have to create daily report in which present ,absent, night shift
people
gt; gt; to
gt; gt; gt; be counted i am using sumproduct but for another day nightshift
changes
gt; gt; den
gt; gt; gt; previous days report changes please help me
gt; gt;
gt; gt;
gt; gt;
i have sent mail from with attachment pls see that
for ref from 100 people only 25 peoples shift changes every week

quot;Bob Phillipsquot; wrote:

gt; Then you will need to capture the shift in a cell(s) on the worksheet and
gt; use that in the SP formula, and update the cell when the shift changes.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;eknathquot; gt; wrote in message
gt; ...
gt; gt; shif changes after every saturday
gt; gt;
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Can you clarify when you say nighshift changes? Perhaps give a worked
gt; gt; gt; example.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove xxx from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;eknathquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; i have to create daily report in which present ,absent, night shift
gt; people
gt; gt; gt; to
gt; gt; gt; gt; be counted i am using sumproduct but for another day nightshift
gt; changes
gt; gt; gt; den
gt; gt; gt; gt; previous days report changes please help me
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;