The details would be specific to your particulars, but here's an
example.........

=IF(AND(SUM(Sheet2!B:B)=4,SUM(Sheet3!C:C)=9),"Got it","Didn't get there")

hth
Vaya con Dios,
Chuck, CABGx3



"Mark" wrote:

i would like to use an IF formula to query two ranges of cells (on separate
worksheets in the same workbook) but don't know how to enter more than one
range in the formula. please can you help