Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Using Right and Len formulas together
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 11-20-2015, 06:50 AM
Debaser's Avatar
Debaser Debaser is offline Using Right and Len formulas together Windows 7 64bit Using Right and Len formulas together 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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulas MSA5455 Excel 3 12-19-2014 01:50 AM
Help with IF or ELSE Formulas tsaladyga Excel 4 07-23-2014 09:04 AM
Need help with formulas please paul_pearson Excel 0 03-20-2013 06:51 AM
Using Right and Len formulas together Formulas in a different language poobear Excel 2 09-18-2011 04:35 AM
Using Right and Len formulas together IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:07 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft