Thread: Using Right and Len formulas together
View Single Post
 
Old 11-20-2015, 06:50 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
You can also use:
=COUNTIF(A1:A12,"*A")

and

=SUMIF(A1:A12,"*A",B1:B12)
Reply With Quote