Using Right and Len formulas together

		Microsoft Office Forums > Microsoft Excel > Excel
Using Right and Len formulas together

11-20-2015, 06:50 AM

Debaser

Windows 7 64bit Using Right and Len formulas together

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

You can also use:
=COUNTIF(A1:A12,"*A")

and

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

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
Formulas in a different language	poobear	Excel	2	09-18-2011 04:35 AM
IF Formulas	mizzamzz	Excel	1	07-08-2010 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:47 PM.