Comparing Tabs

  • Thread starter Thread starter cra88
  • Start date Start date
C

cra88

I have 2 sheets, the first has a list of model numbers I want to search for
in sheet2. I then want to total the number of items in sheet 2 that match the
list in sheet 1.

Thanks
 
Hi,

In a spare column (say, stating from C5) on sheet1, use the formula
=countif(B5:B100,A5) and copy down (till say, cell C50). This will return
you the number of times the items in Sheet1 are present in Sheet2. Now to
know total of items, use the foll formula =countif(C5:C50,">0")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top