LinkBack URL
About LinkBacks
Hello everyone
I'm trying to count the letters "A" in my data tables ..
Results as attachments.
Thank you in advance
Hello everyone
I'm trying to count the letters "A" in my data tables ..
Results as attachments.
Thank you in advance
Hello tax112,
Place this formula in cell N2 and drag it down to N6=COUNTIF($A2:$J2, "*" & $N$1 & "*")Place this Formula in N7=SUM($N2:$N6)
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Not reallyOriginally Posted by Leith Ross
results column N
Hello tax112,
WTF "Not really" ?
Hello tax112,
WTF "Not really" ?
In my file
Row(2: 2): Character "A" in cell A2, D2, E2, G2, only 1
Row(3:3): Character "A" in cell B3, F3, only one .......
Finally the total character "A" appears as 3
I'm trying to solve this problem with .... For next loop
Can someone help me solve the problem
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks