Nov 09 2021 02:09 PM
I have created a excel spread sheet that has columns of data and I simply want to create a formula in a cell that will add all the times the letter A appears in a range of cells in a given column. Can someone help me with that?
Thanks,
Al
Nov 09 2021 02:32 PM
=SUM(LEN(range))-SUM(LEN(SUBSTITUTE(range,"A","")))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
Nov 15 2021 05:47 AM
Nov 15 2021 06:08 AM
Your formula will return the number of cells whose value equals "A".
You asked for a formula that returns the number of times the letter "A" occurs. I interpreted this to mean that if a cell contains "ABACADABRA", it should contribute 5 to the result since there are 5 A's...
Nov 15 2021 06:25 AM