What happens if you use the AutoSum button in cell H4?
AutoSum shows the total in the bottom-right of the page
AutoSum will total the numbers in cells B4:G8
AutoSum will return a #VALUE! error.
AutoSum will total the numbers in cells B4:G4