Cell formula to select values of first blank cell in a row and then the next four cells

Tony,

Sorry if I was not clear. Still we need the sum result from the four left cells next to a blank cell. Range (G4:BF4) will always have numeric values. At times, a row may only have 1 or 2 non-blanks starting from column G. So the sum needs to account for it and calculate result based on that. If a row has non-blank values from column G through L, then the sum needs to get the values from columns (I through L). Please let me know if I am still not clear and thanks for your help.