Count # of times a value is in another spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 spreadsheets. One has entries like: (Spreadsheet 2)

A B C D

5456 Mary 1 4
5456 Mary 2 3
2312 Mary 3 4
2145 Joe 2 2
2345 Joe 2 4
2345 Joe 3 4


The other one has entries like: (Spreadsheet 1)

A B

5456 Mary
2312 Mary
2145 Joe
2345 Joe

I want to put a formula in Spreadsheet 1 to count how many times the values
in Column A is in Spreadsheet 2.
 
Depends what you mean by 'spreadsheet'.
If you mean two worksheets in same workbook, then
=COUNTIF(Sheet2!A:A,Sheet1!A1)
If you mean sheets in different workbooks, then
=COUNTIF('[test book.xls]Sheet1'!$A:$A,A1)
and both book need to be open
best wishes
 

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

Return multiple values in one cell doing a single value lookup 4
Isolating part of text to use in an IF/AND FUNCTION 1
Count Names 2
Insert Cells every other row 1
Excel Spreadsheet Manipulation 21
-- Creating a list of names 1
Scrabble Value calculation for Welsh words 0
excel maxa 4

Back
Top