Why not try a SUMIF function or COUNTIF function.


"Bradley" wrote:

I am trying to write and IF statement with a VLOOKUP. I only want the value
to be returned when the IF column is equal to a set value.

For example, I have a data worksheet which has months and document #'s and
total hits. I am creating another worksheet that wil search the data page
and return the number of hits for the document, but I want to be able to
compile by month. So when month is equal to 200501 I want the value for the
contract to be returned.

This is what I have written:

=IF(('DOC TOTALS'!C1=200501),VLOOKUP(E2,'DOC TOTALS'!A:C,2,FALSE),0)

But this only will search the C1 row to see if it is =200501, I want the
whole column to be searched.

Thank you
Bradley