Excel SUM TOTAL (Not Programming)
Hi
If you wanted to use filtering, then assuming your Data is column A,
with a heading in A1 called Data, and your values in cells A2:A100.
Insert a new row above your header row and enter in cell A1
=SUBTOTAL3(A3:A100)
Place cursor in cell A2 and DataFilterAutofilter
Use the dropdown to select the number required, and cell A1 will display
a count of the visible rows of data containing that number.
--
Regards
Roger Govier
"HotRod" wrote in message
...
THANKS, I was hoping for more of a filtering type answer as the users
aren't even this advanced.
|