Urgently need help with a formula!!!

[billosullivan]

Hello,

I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to look at D7 through to J7 and look for a value of "Yes".
the total amount of "Yes" boxes should then be multiplied by J5 and the
result shown in L7.

It is for the purpose of a timesheet, I'm trying to calculate fuel
allowances The Value C7 "Y" indicates that i drove and the values D7
through to J7 are days of the week Monday to Sunday, For each day i
drove somewhere I enter "Yes" the amount i'm allowed for my fuel
allowance is displayed in J5 so you can see that i need to multiply the
days of the week that i drove by the allowance.

I hope this is explained well enough!

Any help you might be able to give would be greatly appreciated!

Thanks,
Bill

 

[Dave Peterson]

Put this in L7:
=if(c7<>"y","",j5*countif(d7:j7,"Yes"))

 

[Jim Thomlinson]

in L7 place this formula...

=if(c7<>"Y", 0, countif(D7:j7, "Yes")*J5)