Not a formula, but can be done by VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lb" wrote in message
...
I have been told that there is a formula that will allow me to use a
worksheet to sort data by clicking on each cell and by clicking it will
add 1
to the cell's value