Hi,

I can't go to KK17 because I don't have Excel 2007 so change your range and
this should do it

=COUNTIF(D17:IV17,"SLS")

Change the SLS to each of your values

Mike

"John Blackwell" wrote:

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?