Figuring totals by periods (Monthly, Quarterly, etc.)

[nd2no]

Column E - input # of miles
Column F - Keeps running total of all miles
Column G - Specifies what period Column E miles are travelled in.

How can I ask my worksheet to keep up with miles per period?

I am paid a basic cpm for all miles I run, but also get a bonus if
run more than 18,000 miles within the same period.

(Columns A - D keep up with trip numbers, delivery dates, etc.

 

[Frank Kabel]

Hi
to sum for a specific period use
=SUMIF(G:G,"period1",E:E)

now you could use something like
=IF(SUMIF(G:G,"period1",E:E)>18000,"Bonus","No Bonus")

 

[nd2no]

Perfect! Thank you