View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do you count how many times a cell is entered

In general this is something Excel wasn't designed to do.
There are ways around, but be careful.

Here's a link:

http://www.mcgimpsey.com/excel/accumulator.html

but again, make sure you read the last sentence too.

--
Kind regards,

Niek Otten

"sammberg" wrote in message
...

How do you count how many times a cell is entered with a particular
string.

Example: If input cell is A1 and count cell is C1 and count string is
1K4. Then I want C1 to counts everytime 1K4 is entered in to A1.


--
sammberg
------------------------------------------------------------------------
sammberg's Profile: http://www.excelforum.com/member.php...fo&userid=1019
View this thread: http://www.excelforum.com/showthread...hreadid=521413