Word count Deadline

tgreene2856

New Member
Joined
Apr 10, 2013
Messages
28
https://drive.google.com/open?id=0B474It8rivBNMXYyWEI5U09TRHM Click the link to see the Workbook. I am trying to setup my word count log to have two-word count goals. One for the whole novel and one for weekly. I use two pie charts that fade away as I accomplish my goals. My issue is my weekly pie is always about a quarter left on the pie. I want it setup to be whole from the start.

The reason is I am using my whole novel word count formula for weekly. You will have to check the link to see this, but I have four dates. Beginning and end for the novel and week. Based on that I put my goal, which is 85000 for the novel. My weekly goal is 17000 while I already have 13000 words written. My actual goal is 4000 words. I want to set it up to put the actual word count 4000 instead of 4000 on top of what I already have.

Please help. I made the file available to anyone with the link, please let me know if you can't see the file.

Thanks

Tim
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

tgreene2856

New Member
Joined
Apr 10, 2013
Messages
28
Full pie would be at 4000 words. At 17000 it removing existing words already written.
 

vaskov17

Well-known Member
Joined
Apr 27, 2011
Messages
920
Is the full pie always going to be 4000? Or is it the 17000 weekly goal minus whatever is currently written?
 

tgreene2856

New Member
Joined
Apr 10, 2013
Messages
28
Sorry about the cross posting. To answer the questions, the full weekly pie would be whatever I put as the weekly goal. This week I want to write 4000 but next week I want to write 6000.
Or is it the 17000 weekly goal minus whatever is currently written?
Vaskov17. Right now that is how it is setup. Since I have 13000 words, and wanted 4000 as my goal I had to put in 17000. I don't want to do that.

What I am looking for is something like this:

Example =Vlook H6 in D jump 2 add F27 through F34.

Whatever date I put in H6 will search Column D for that date and then jump over two columns and add that cell and the six below it. That way the formula in P10 will see my word count goal is 4000. The seven cells being added up will be 0 until I add the numbers to them. As I add numbers the total words will go up and the pie chart will go from being full to empty.

I hope this helps.

Sorry again about the cross posting. If anyone needs the workbook it is attached to that post in case my link to my Google Docs isn't working.

Tim
 

tgreene2856

New Member
Joined
Apr 10, 2013
Messages
28
Found a better way to say this.

Example =Vlook H6 in D offset by 4 add the cell is lands on and the six below
 

tgreene2856

New Member
Joined
Apr 10, 2013
Messages
28
Solved it. Incase anyone stumbles onto this thread, the solution is. =SUMPRODUCT(SUM(INDIRECT(ADDRESS(MATCH(N14:N20,D14:D378,0)+12,MATCH(F13,D13:F13,0)+3))))

Tim
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,480
Members
414,143
Latest member
lonnie451

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top