Hi,

I am need a formula in the cell BG (no array formula please) that searches through the current row starting from column G through BF for the first BLANK cell and returns the total values from the cell to the right of Blank cell and the next 3 cells to the right of it)

For example: M4 is the first blank cell in row 4, then I need to get the total of (L4 through I4) which would be 13.
G4=5
H4=2
I4=3
J4=1
K4=4
L4=5
M4=BLANK
N4:BF4=BLANKS

Thanks in advance for any help.