Excel 2007 - I need to - find first non blank cell in row and then sum that and next 11 cells. Some of these 12 cells may be blank. I have been using this formula which is not working: 
=SUM(OFFSET(CELL("address",INDEX(B7:BI7,MATCH(FALSE,ISBLANK(B7:BI7),0))),0,12))
in this particular row the first populated cell is AM7 which is returned correctly in the CELL part of the formula above but obviously I have not put it together correctly. Also it may be necessary to consider rows where the first value is within the last 12 columns and therefore there may be less than 12 columns to sum. The table contains 1270 rows starting at row 7 and columns B to BI inclusive. Please could you tell me where I have gone wrong. Thanks in advance