COUNTA Function
Hi,
You could use
=COUNTIF(A1:A100,"W*")
but this is not limited to 13 characters, so here is an elegent solution:
=COUNTIF(A1:A100,"W"&REPT("?",12))
--
Thanks,
Shane Devenshire
"Karen" wrote:
I have a formula that counts the active cells in a range
=COUNTA(A1:A10)
Someone inadvertently put a decimal in one of the cells and it counted the
cell when I didnt want it to. All of the cells will count the cells that
contain a part number, which will always start with a €śW€ť and have a total of
13 characters
Example: W032356412545
Is there a way to set up the COUNTA formula so it only counts the cells that
contain the 13 character part number that starts with the letter W and
eliminate the issue I had if someone inadvertently types in anything else?
Any help would be greatly appreciated
Thanks, Karen
|