When you want to sum a range such as cells G10 to G40 then the formula you need to use is =sum(G10:G40). That is what you are trying to do in G41.

From what your explanation it soundslike you are trying to have the sum of flight hours for the month and for the past 30 days (which should change every day). Is that correct?