We help IT Professionals succeed at work.

Excel Formula that is like a vlookup but with counting

Murray Brown
Murray Brown asked
on
Hi. In the following to Excel sheets I want to put a formula in cell H6 that looks at the number in D6 and gets a count of 4 from column A in the second sheet

1
2
Comment
Watch Question

Analyst Assistant
Commented:
Not sure how you arrive at 4 but if you wanted to count how many times the value in D6 on Sheet1 appeared in column A of Sheet2 you could use this.

=COUNTIF(Sheet2!$A:$A, D6)
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Great. Thanks