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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Help 2
What type of "lookup" 3
Vlookup in multiple sheets 2
Match and delete rows on two different sheets from reference numbers 4
add hyperlink using sheet names and cells(i,j) 3
Help to shorten a formula 5
Find Duplicates Across Two Sheets, Delete Everything else. 2
SUMIF or SUMIFS help 1

Back
Top