G
grizzly6969
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
I was given this formula to use and I can make it work if every thing
including the formula is on the same spred sheet but if I put this formula on
sheet 2 or 3 to pull the information from sheet 1 it will not work. Is it me
or is it the formula
Sorry for my ignorance
=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(Sheet1!A1:A100>=$E$1),--(Sheet1!A1:A100<=$F$1))
=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
I was given this formula to use and I can make it work if every thing
including the formula is on the same spred sheet but if I put this formula on
sheet 2 or 3 to pull the information from sheet 1 it will not work. Is it me
or is it the formula
Sorry for my ignorance
=SUMPRODUCT(--(Sheet1!B1:B100="John
Doe"),--(Sheet1!C1:C100="sick"),--(Sheet1!A1:A100>=$E$1),--(Sheet1!A1:A100<=$F$1))