New Excel User - Simple Word Count Tracker Help

Timotheus_k

New Member
Joined
Dec 1, 2009
Messages
3
Hello all,

This is probably a very simple challenge that I've run into, but I am a writer, and I am currently trying to create a spreadsheet that tracks how many words that I type daily.

I am currently using Google Docs spreadsheet application online, but have access to Office 2007 on a computer running Windows 7. (I use the online version via Google Docs since it allows me to write from any computer with internet access-- if using Office '07 would help, I'd be happy to do so.)

Here is what I would like to create, but simply don't have the skills or understanding:

I have a goal of writing 2,000 words per day, so I wanted to create a spreadsheet that had the following columns:

Date:
Number of Words When Began:
Number of Words When Finished:
Total for the Day:
Met Exceeded Goal? (This, I was hoping, could be a red negative number if I was short on my 2,000 words, and a green positive number if I was at or above my goal of 2,000 words.)

The problem I keep having is that my logic must be flawed-- I cannot seem to get these columns to jive and work properly. I keep coming out with negative numbers and an inaccurate count.

Any help in explaining to me what I'm doing wrong, or the best way to go about creating this speadsheet would be greatly appreciated, and already I thank you for taking the time to even read my request.

Respect,

Tim
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
Welcome to MrExcel board...

so post what formula you are currently using
 
Last edited:

Timotheus_k

New Member
Joined
Dec 1, 2009
Messages
3
Thank you for the welcome!

Here is what I have in each cell that I am using so far:

A1 - Title/Heading :: formula=none

A2 - Date Last Updated :: forumla=none

A3 - Blank for visual asthetics :: formula=none

A4 - Date:: formula=none
B4 - Words When Began ::formula=none
C4 - Number of Words When Finished:: forumla=none
D4 - Total for the Day:: formula=none
E4 - Met/Exceeded Goal? :: formula=none

A5 - 11/30/2009 :: formula=none
B5 - 0 :: formula=none
C5 - 459 :: formula = none
D5 - 459 :: formula=C5-B5
E5 - 1541 :: formula= 2000-D5

I think that I'm close, but the problem lies in the 'Met/Exceeded Goal?' number. It's coming out as a positive 1,541, even though that is the number that I am short. I think that my logic is off, and I don't know how to express the outcome I'm looking for in a formula.

A bonus would certainly be showing the number in green if positive or equal, and red if negative, but not a big deal if that is difficult.

I hope the above cell listing is clear. If not, let me know what else I can provide, and in what format, and I'll be happy to do so.

- Tim
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
you need to reverse the order on that formula

Excel Workbook
ABCDE
1Title/Heading
2Date Laste Updated
3
4DateWords When BeganNumber of Words When FinishedTotal for the DayMet/Exceeded Goal?
511/30/20090459
Sheet3


then format the cell as a number with negative in red
 

Timotheus_k

New Member
Joined
Dec 1, 2009
Messages
3
Excellent!

Thank you so much, that helped a great deal. I knew I was missing something in my logic. :biggrin:
 

Forum statistics

Threads
1,081,845
Messages
5,361,663
Members
400,643
Latest member
RockStar89

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top