Microsoft Office Forums - View Single Post - How to assign numbers to letters and then create a formula to add them together for a rota

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

View Single Post

Old

03-30-2017, 02:13 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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).

Reply With Quote