Thread: week to date percent to goal

1. week to date percent to goal

Good Morning all,

I am in need of creating a if then formula that will give me a w.t.d. % to goal.

I have attached a sheet w/ data filled in through Wed. I want to be able show the % of sales to goal week to date as the week progresses.

2. cvbs,

Your use of merged fields causes problems (at least for me) in calculating the value you want.

If you remove the merged fields it works quite simply as follows:
=ROUND(SUM(\$B\$3:\$H\$3)/OFFSET(\$A\$6,0,COUNT(\$B\$3:\$H\$3)),4)

wtd.JPG

HTH

3. cvbs,

You might want to consider the formulas in the attached for the other columns so only values for entered days show.
wtd2.JPG
Modified PERCENT TO GOAL.xlsx

HTH

4. RG,

Thanks for the reply. I see that your formula does work w/o problem if there are no merged cells, however that is something that I can not change w/in this sheet. The results keep coming back w/ "formula results = volatile". I will have to keep searching for a way.
cvbs

5. cvbs,

Figured it out.
=ROUND(SUM(\$B\$3:\$O\$3)/OFFSET(\$A\$6,0,(COUNT(\$B\$3:\$H\$O))*2-1),4)

The above should work as it does in my test. It's a little more complicated though but since you can't get rid of the merged cells we'll have to live with it.

HTH

6. The Following User Says Thank You to RetiredGeek For This Useful Post:

cvbs (2015-01-15)

7. RG,

Thank You !!! It is excellent !!! Thanks for the perseverance YOU are the man. Very much appreciated.

cvbs

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•