I'm using Excel 2007

In worksheet W1 I have a table of values with column names for the table in row 1 and row names in column A.
I have marked certain of the intersects in this table with an X
In a separate worksheet W2 I have a list of values ColumnName.RowName (not necessarily unique or in any particular order)

I have applied conditional formatting to my table so that cells that contain an X and for which there is no match on the list in W2 are highlighted

THis uses a formula applied to the data in the table similar to
=AND(B2="X",ISNA(MATCH($A2&"."&B$1,LookupList,0)))

(note the relative references)


This works fine. However I would also like to be able to count the highlighted values. I can't seem to find a way to do this.

Can anyone help

Thanks in advance