Sum multiple columns, one with a variable

Hi I need a formula that will calculate the total of 

 

– all in column C * £35

– all in Column D * £35

– all in Column E where there is a number, ((multiplied by the figure in Colum B) multiplied by 0.1))

 

 

A B C D E
    70
    Day 1
  Fri 24 Mar
    B/T M/P O/T
Employee 1 250 1   1
Employee 2 250  2  1  1
Employee 3 350      
Employee 4 233      
Employee 5 196      

By: Hussain

Leave a Reply

Your email address will not be published. Required fields are marked *