G
Gina
This is the formula I am currently using:
=SUM(IF(Data!$I$2:$I$2000="Recordable",IF(Data!$A$2:$A$2500>=DATEVALUE("1/1/1995"),IF(Data!$A$2:$A$2500<DATEVALUE("1/1/1996"),Data!$L$2:$L$2000,0),0),0))
Basically I'm trying to find the total of recordable incidents that happened
within a date range, where the individual records are entered on a worksheet
called "Data".
What I'd like to be able to do is build this formula once, and then be able
to drag it across cells to calculate for other years as well. What I did was
make a new worksheet in the workbook called "List Values". Cell A2 has the
value 1/1/1995, A2 has 1/1/1996, etc.
Am I on the right track? Is there a way this could work?
=SUMPRODUCT(--(Data!$A$2:$A$2500>=ListValues!A2),--(Data!$A$2:$A$2500<=ListValues!A3),--(Data!$L$2:$L$2000,0)
Help?
=SUM(IF(Data!$I$2:$I$2000="Recordable",IF(Data!$A$2:$A$2500>=DATEVALUE("1/1/1995"),IF(Data!$A$2:$A$2500<DATEVALUE("1/1/1996"),Data!$L$2:$L$2000,0),0),0))
Basically I'm trying to find the total of recordable incidents that happened
within a date range, where the individual records are entered on a worksheet
called "Data".
What I'd like to be able to do is build this formula once, and then be able
to drag it across cells to calculate for other years as well. What I did was
make a new worksheet in the workbook called "List Values". Cell A2 has the
value 1/1/1995, A2 has 1/1/1996, etc.
Am I on the right track? Is there a way this could work?
=SUMPRODUCT(--(Data!$A$2:$A$2500>=ListValues!A2),--(Data!$A$2:$A$2500<=ListValues!A3),--(Data!$L$2:$L$2000,0)
Help?