🖥️ R coder
🎮 Gamer
🎧 DJ
🌈 Boston is home
🌴 FL for now
=SUMPRODUCT(
SUBTOTAL(103,OFFSET(B2,ROW(B2:B1000)-ROW(B2),0,1)),
--(MATCH(B2:B1000,B2:B1000,0)=ROW(B2:B1000)-ROW(B2)+1)
)
=SUMPRODUCT(
SUBTOTAL(103,OFFSET(B2,ROW(B2:B1000)-ROW(B2),0,1)),
--(MATCH(B2:B1000,B2:B1000,0)=ROW(B2:B1000)-ROW(B2)+1)
)