LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Making a cell count the amoun of entries that has been put into it

I use Excel to teach my grandson math. In column A is a number. In
column B he has to type a number. In column C is the formula "=a1/a2" If he
types the correct number in column B the correct answer will appear in column
C. I also have the correct answer listed in column D. His instructions are to
type the correct number in column B and if he does then the answer in column
C will match the number in column D.
Now what I would like to do is to be able to have a column that counts
the number of times he types a number in column B so that I will know that he
is actually doing the work and not just guessing by typing numbers in column
B until he gets the correct answer.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using SEARCH in a single cell to COUNT multiple entries of same te tcbooks Excel Programming 3 January 16th 09 08:54 PM
Using SEARCH in a single cell to COUNT multiple entries of sam tcbooks Excel Programming 0 January 15th 09 10:07 PM
Using SEARCH in a single cell to COUNT multiple entries of same te JBeaucaire[_90_] Excel Programming 0 January 15th 09 08:17 PM
Count number of times entries are made in a cell [email protected] Excel Programming 3 July 10th 08 06:26 PM
count the number of cell entries after filtering Gazza Excel Discussion (Misc queries) 2 March 16th 06 01:31 PM


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"