If I understood you correctly.

=SUM(COUNTIF(D18:KK18,"SLS"),COUNTIF(D18:KK18,"SLM "),COUNTIF(D18:KK18,"MLS"),COUNTIF(D18:KK18,"MLM") ,COUNTIF(D18:KK18,"AH"),COUNTIF(D18:KK18,"FH"),COU NTIF(D18:KK18,"MS"),COUNTIF(D18:KK18,"EV"))

Is this what you want?


"John Blackwell" wrote in message
...
Can anyone help with this formula problem.

I'm working on a large workbook and in row D18:KK18 I have a series of
eight
different values (i.e. SLS, SLM, MLS, MLM, AH, FH, MS, EV). In row
D17:KK17
I have the number of occurence of these values.

Is there a CountIf (or other) formula I can use that will recognise the
occurences of each value in row 18 and sum the number of occurences in row
17?