Hey guys, in a column (B) i have 2 letters H or A , and i wanna average the last 10 numbers if the letter in column B is H, i came up with this formula but the average doesn't seem to be the same if i do it manually. =AVERAGEIF($B$3:$B$100,"*H*",(OFFSET(C3,COUNT(C3:C100),0,-10)))
Bookmarks