Hi Expert,
Attempting to count total specific numbers in a large data when specific number appears....
Using filter takes lot of time but wondering some function may be available
( Excel 2007)

Example


A B C
2 6 4
4 8 6
6 2 8
6 8 2
2 6 6
2 4 8
6 8 4
8 2 4
8 6 2
Goal seeking

Task: use number from column A (say 6) and count how many time 8 appears when 6 appeared in column A

Result( Counted Manually)
when 6 appeared (column A) , 8 appeared three times (from column B & C)

Thanks
Karnik