title: TypeError: unsupported operand type(s) for +: 'NoneType' and 'float'
body: <p>Trying to sum the total of excel cell data inputs ('123.111', '112.1', '123') and then divide them by a count to get the avg. I keep on getting type errors and im not sure why, unless its because the cell data type is not compatible. Also trying to work out the min and max if anyone can help </p>
  
  <pre><code>total = 0
  count = 0
  for cellObj2 in rows2:
      State = str(cellObj2[3].value)
      if 'Queensland' in State:
          newtotal = cellObj2[1].value
          total = newtotal + total
  
  print(total)
  </code></pre>