Counting cells with multiple complex criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Counting cells with multiple complex criteria

FAQ

Thread Tools

Display Modes

12-04-2012, 01:56 AM

TishyMouse TishyMouse is offline

Windows XP Counting cells with multiple complex criteria

Office 2007

Novice

Join Date: Feb 2012

Posts: 22

Thanks, but how do I sum across a row of the table given that the true/false of the condition evaluation for each cell is based on a relative reference?

i.e. in cell B2 'TRUE' would be
=AND(B2="X",ISNA(MATCH($A2&"."&B$1,LookupList,0)))
whereas in cell B3 it would be
=AND(B3="X",ISNA(MATCH($A3&"."&B$1,LookupList,0)))

« Previous Thread | Next Thread »

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
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
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:11 PM.