![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ranking with multiple criteria | angie.chang | Excel | 0 | 08-14-2012 04:49 PM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |
![]() |
apolloman | Excel | 6 | 08-24-2011 05:38 AM |
How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |
![]() |
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |