Hi,

v2:V690 = 8386 and r2:r690 = 1/20/09

=SUMPRODUCT(--(V2:V690=A1),--(R2:R690=B1))

And in A1 enter 8386 and in B1 enter 1/20/09

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"George W. W." wrote:

I have a work sheet that I want to report to another page. I am putting
togehter a production tracking tool, and need to pull information from two
diffren colums in the work sheet and count them. Basically what I want is to
be able to if v2:V690 = 8386 and r2:r690 = 1/20/09 then count 1 for every
time it happes in the same row. I've tried this several diffrent was if
then, count, sum, what am I doing wrong and how do I do it right. this was
the last effort

=COUNTIFS(IF(LCR!V2:V690,B4),(LCR!R2:R690,G3))
Please help!