Hi Guys, I need some help with the below formula. I was develop to sum horizontally and I cat seem to change it to work vertically. Please assist. =LOOKUP(H2,SUBTOTAL(9,OFFSET(A2,,,,COLUMN($A$1:$G$1)))) Lookup value should be based n b12