=IF(--SUMPRODUCT(--(ISNUMBER(MATCH(Sheet1!$B$3:$B$15,B6,0))))0,SUMPR ODUCT(--(ISNUMBER(MATCH(Mon!$E$7:$E$51,Sheet1!$A$3:$A$15,0 ))),--(ISNUMBER(MATCH(Mon!$K$7:$K$51,Sheet1!D$3:D$15,0)) ),--(ISNUMBER(MATCH(Mon!$F$7:$F$51,Sheet1!$E$3:$E$15,1 ))),--(ISNUMBER(MATCH(Mon!$F$7:$F$51,Sheet1!$F$3:$F$15,-1)))),"None")

Currently i have this formula to look up through many ranges of cells and to
count up how many times it matches. unfortunatly i need it to do what it does
only per Row. Not just through all the ranges at once but too look up the
info in one sheet per row and search for it in the other per row and if i
matches per row to count it.

Current layout is this
(Sheet1) each item in each row is going to be diffrent (#### means4 random
#'s

Name Date ####'s Time in Time out
Name Date ####'s Time in Time out
Name Date ####'s Time in Time out
Name Date ####'s Time in Time out

(Mon) colums depicted by ** are irrelevant information but cannot be deleted
** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info
** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info
** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info
** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info

(Report)
Name Long formula above
Name Long formula above
Name Long formula above
Name Long formula above

i need the formula to look at the name in report
then find the name however many times it occurs in sheet1
then look at the info that is in the same row as the name
and then find the items in a row with the items in Mon
then count it up how many times it occurs for that name.

Hop this helps

--
RG