Problem:
Calculating the total number of times any of the numbers in List1 (column A) appear within List2 (column B).
Solution:
Use the SUM and COUNTIF functions as shown in the following Array formula:
{=SUM(COUNTIF(B2:B9,A2:A4))}
Problem:
Calculating the total number of times any of the numbers in List1 (column A) appear within List2 (column B).
Solution:
Use the SUM and COUNTIF functions as shown in the following Array formula:
{=SUM(COUNTIF(B2:B9,A2:A4))}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks