how do I count how many times the letter A appeared on the left or right ?
AA|AA|AE|AZ|XA|NA and so on
how do I count how many times the letter A appeared on the left or right ?
AA|AA|AE|AZ|XA|NA and so on
take your pick
=SUM(COUNTIF(A1:F1,{"AA","*A*"}))
AA will be counted as 2
=COUNTIF(A1:F1,"*A*")
AA will be counted as 1
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks