The sum is =SUM(B5:B56)
From B23-B56 cells have #DIV/O!
Formula for B23-B56 cells is =(12500/OFFSET(Data!C$27,(ROW(B19)-1)*45,0,1,1))*(OFFSET(Data!C$64,(ROW(B19)-1)*45,0,1,1)-OFFSET(Data!C$27,(ROW(B19)-1)*45,0,1,1))
When you say post the cell content (the formula) of a cell that is currently producing a #DIV/0 in your sum range
How do I add it to make it work?