K
Kathy - Lovullo
I'm having a problem with what should be an easy countif formula.
I have data on multiple sheets which have been imported into excel from
another program. I want to count the number of times an account number(col
B) appears on Sheet 1 for the corresponding account number on sheet 2 (column
A).
Below is the formula I am using; however it is not working.
=COUNTIF('Sheet1'!$B$2:$B$1239,Sheet2!A2)
However, if I simply re-type the account number in sheet 1, this formula
works correctly. How can I correct the formula (or data) to have the formula
work without re-typing all my account numbers?
I have data on multiple sheets which have been imported into excel from
another program. I want to count the number of times an account number(col
B) appears on Sheet 1 for the corresponding account number on sheet 2 (column
A).
Below is the formula I am using; however it is not working.
=COUNTIF('Sheet1'!$B$2:$B$1239,Sheet2!A2)
However, if I simply re-type the account number in sheet 1, this formula
works correctly. How can I correct the formula (or data) to have the formula
work without re-typing all my account numbers?