jacob has 10 chairs in cell B1
penny has 20 chairs in cell B2
dolly has 20 chairs in cell B3

My formula is this and is in cell D1: =SUMIF(A1:B4,A1,B1:B4) and my results give me 10.

Problem: I would like to click a hyper link on cell d1 to take me to my results is this possible?