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

  • Thread starter Thread starter nd2no
  • Start date Start date
N

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.
 
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")
 
Back
Top