I have a spreadsheet that totals values from cells to a summary in another cell.
THe formula in cell M1 is =SUM(IF(ISNUMBER(FIND($L$1,M$9:M$260)),VALUE(LEFT(M$9:M$260,FIND($L$1,M$9:M$260)-1)),0))
the formula will total all the "L" values in the coumn, I wish to add another value into the cell as below
How can I adapt the formula to include the value of 4 in cell M3, this would also need to include all other values in the entire column that are 2 spaces to the left of "B"
Any help appreciated.
THe formula in cell M1 is =SUM(IF(ISNUMBER(FIND($L$1,M$9:M$260)),VALUE(LEFT(M$9:M$260,FIND($L$1,M$9:M$260)-1)),0))
the formula will total all the "L" values in the coumn, I wish to add another value into the cell as below
How can I adapt the formula to include the value of 4 in cell M3, this would also need to include all other values in the entire column that are 2 spaces to the left of "B"
Any help appreciated.