Urgently need help with a formula!!!

[BillOSull]

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

 

[Sandy Mann]

Bill,

In L7 try:

=IF(C7="Yes",COUNTIF(D7:J7,"Yes")*L7,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Pete_UK]

Enter this formula in L7:

=IF(C7="Y",COUNTIF(D7:J7,"Yes")*J$5,0)

I think this is what you want.

Hope this helps.

Pete

 

[Marcelo]

Hi Bill, if I understand correctly what you are loking for try:

=if(c7="Yes",(contif(d7:j7,"Yes")*j5),0)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"BillOSull" escreveu:

 

[BillOSull]

Pete,

Thank you very much, this worked a treat!

I really appreciate the quick response also.

Thanks again!

Bill

 

[Pete_UK]

Thanks for the feedback, Bill - glad to be of help. I just happened to
be browsing when your post came through.

Pete

 

[Dave F]

=IF(C7="Y",COUNTIF(D7:J7="Yes")*J7,"")