How to assign numbers to letters and then create a formula to add them together for a rota

		Microsoft Office Forums > Microsoft Excel > Excel
How to assign numbers to letters and then create a formula to add them together for a rota

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-30-2017, 02:13 PM

xor

Windows 10 How to assign numbers to letters and then create a formula to add them together for a rota

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

How about:

=SUM(COUNTIF(A13:G13,{"L","E","9-4","12-8","AD","A L"})*{8;7,5;7;8;7;7,4})

(I assume you really mean there should be a space between A and L).

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Swapping column and row formats. Letters to numbers etc.	AdamNT69	Excel	2	10-17-2016 08:44 AM
more symbols for super/subscript numbers and letters	djc	Word	5	03-13-2015 10:54 AM
Captions mixing letters and numbers	trew	Word	7	11-21-2012 12:54 AM
Creating TOC with letters and numbers	tanababa	Word	1	04-28-2011 01:35 AM
mailmerge with letters of a different numbers of pages	roel1972	Mail Merge	0	02-21-2011 11:45 AM

Other Forums: Access Forums

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