I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is it
possible to add a third criteria so it will track from (Jan. 01/09 to March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates if
possible

--
grizz

One way, if you put the start and end dates in say N1 and N2.

=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(A1:A100=N1),--(A1:A100<=N2))

Regards,
Alan.
"grizzly6969" wrote in message
...
I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is it
possible to add a third criteria so it will track from (Jan. 01/09 to
March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates if
possible

--
grizz

Add two conditons... one to check beginning of the period, second to check
< end of the period...

=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(Sheet1!A1:A100=$E$1),--(Sheet1!A1:A100<=$F$1))

with E1 having the beginning and F1 the end of the period
"grizzly6969" wrote:

I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is it
possible to add a third criteria so it will track from (Jan. 01/09 to March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates if
possible

--
grizz

I'm getting a ( #value! ) return am I doing somthing wrong
--
grizz


"Sheeloo" wrote:

Add two conditons... one to check beginning of the period, second to check
< end of the period...

=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(Sheet1!A1:A100=$E$1),--(Sheet1!A1:A100<=$F$1))

with E1 having the beginning and F1 the end of the period
"grizzly6969" wrote:

I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is it
possible to add a third criteria so it will track from (Jan. 01/09 to March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates if
possible

--
grizz

Download the file I tested with from
http://wikisend.com/download/440880/Sample.xls
and compare with what you are doing...

or upload your file to wikisend and paste a link here...

"grizzly6969" wrote:

I'm getting a ( #value! ) return am I doing somthing wrong
--
grizz


"Sheeloo" wrote:

Add two conditons... one to check beginning of the period, second to check
< end of the period...

=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(Sheet1!A1:A100=$E$1),--(Sheet1!A1:A100<=$F$1))

with E1 having the beginning and F1 the end of the period
"grizzly6969" wrote:

I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is it
possible to add a third criteria so it will track from (Jan. 01/09 to March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates if
possible

--
grizz

Thanks for the help
--
grizz


"Sheeloo" wrote:

Download the file I tested with from
http://wikisend.com/download/440880/Sample.xls
and compare with what you are doing...

or upload your file to wikisend and paste a link here...

"grizzly6969" wrote:

I'm getting a ( #value! ) return am I doing somthing wrong
--
grizz


"Sheeloo" wrote:

Add two conditons... one to check beginning of the period, second to check
< end of the period...

=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(Sheet1!A1:A100=$E$1),--(Sheet1!A1:A100<=$F$1))

with E1 having the beginning and F1 the end of the period
"grizzly6969" wrote:

I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is it
possible to add a third criteria so it will track from (Jan. 01/09 to March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates if
possible

--
grizz

You must be, both Sheeoo's solution and mine work. Try posting the formula
you're using and the cells you've entered the start and end dates in, it
should be easily resolved.

"grizzly6969" wrote in message
...
I'm getting a ( #value! ) return am I doing somthing wrong
--
grizz


"Sheeloo" wrote:

Add two conditons... one to check beginning of the period, second to
check
< end of the period...

=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(Sheet1!A1:A100=$E$1),--(Sheet1!A1:A100<=$F$1))

with E1 having the beginning and F1 the end of the period
"grizzly6969" wrote:

I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John
Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is
it
possible to add a third criteria so it will track from (Jan. 01/09 to
March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates
if
possible

--
grizz