Dividing Date Cell Question

[nockam]

That did the trick, but now I cant get my formula that references th
date only cell to work. If i type the date in manually it works jus
fine.

=SUMPRODUCT((MTD!$L$6:$L$2000="VTO")*(MTD!$A$6:$A$2000=$B$42)*(MTD!$K$6:$K$2000))

is the formula. the date cell is on the MTD sheet, and everything i
that formula needs to reference everything on the MTD sheet excep
"$B$42" because that is the date i want to return the information for.
(MTD stands for month to date and this sheet contains 1 months worth o
information)

Basically all i am doing is getting all the entries for a particula
date, then if it matches a certain code like vto, or mto, have it ad
the hours for those records. so in the end i can say ok, on ____ day
we had ____ hours of VTO same with MTO and a few others. This formul
is just to find the total hours for 1 particular day, and on
particular code.

Whatever day is in "$B$42" and "VTO" code. The data formats are se
exaclty the same and as i said before if i type in the date manually i
the cell that now has "=INT(A6)" in it everything works. my row rang
is row 6-2000 and i changed =INT(A1) to =INT(A6) and put it in row
so that the formula is referencing everything correctly. Any mor
input woudl be greatly appreciated. thank

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT((MTD!$L$6:$L$2000="VTO")*(INT(MTD!$A$6:$A$2000)=INT($B$42))
*(MTD!$K$6:$K$2000))