View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Count non consecutive columns

Hello - hoping someone can help me out.

I have a worksheet with a number of columns and I am attempting to
count the occurances where the value is =100% in columns headed "% of
Target Achieved" on a row-by-row basis.

The value in these columns will either be a % (positive or negative) or
"-"
Values in other columns that I do not want included are numbers or
blank.

Thankyou