Hi all



I'm a novice at formula and have searched the internet to find out the answer to my question. I have cobbled together a formula, which works but I feel is too long and there must be an easier way of doing it.

I read about arrays but do not understand them and I am not sure if it's the right thing to use for this calculation.

In brief, I want to be able to add the cells together in rows that contain E (which will equal 7.5) L (which will equal 8) and variations of numbers i.e. 12-8 (which will equal 8).

This is an example of what I have put together from copying the first bit from another post. I do not understand what the first bit means, but it does work:

=IF(COUNTIF(A13:G13,"="""),"",SUM(COUNTIF(A13:G13, "=L")*8,COUNTIF(A13:G13,"=E")*7.5,COUNTIF(A13:G13, "=9-4")*7,COUNTIF(A13:G13,"=12-8")*8,COUNTIF(A13:G13,"=AD")*7,COUNTIF(A13:G13,"=A L")*7.4))

Thank you for taking the time to read my post, I hope you can help as it will save so much time checking hours for a rota.