Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-30-2012, 10:04 AM
TishyMouse TishyMouse is offline Counting cells with multiple complex criteria Windows XP Counting cells with multiple complex criteria Office 2007
Novice
Counting cells with multiple complex criteria
 
Join Date: Feb 2012
Posts: 22
TishyMouse is on a distinguished road
Question Counting cells with multiple complex criteria

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
Reply With Quote
 



Similar Threads
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
Counting cells with multiple complex criteria Selecting blank cells in criteria 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
Counting cells with multiple complex criteria Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft