Totalling monthly costs automatically

B

BeSmart

I need a formula where the $????'s are that adds the weekly activity for the month and calculates it by the appropriate rate. Each week column starts on a Sunday. that relate to a specific month and multiply by a rate,
putting the June total into the June column, July into July column et

Jun Jul Jun cost July cos
6 13 20 27 4 11 18 25 Rate $???? $????
1 1 1 $50

Any help would be appreciated...
 
Top