Count with multiple conditions

		Microsoft Office Forums > Microsoft Excel > Excel
Count with multiple conditions

FAQ

Thread Tools

Display Modes

bundy5150 Count with multiple conditions 02-17-2011, 08:49 AM

Colin Legg Hi, Please see if the... 02-21-2011, 03:10 AM

bundy5150 It may work, the problem is I... 02-22-2011, 08:39 AM

bundy5150 Oops, sorry It works... 02-22-2011, 09:03 AM

Colin Legg Ah, sorry if that confused... 02-22-2011, 10:00 AM

02-22-2011, 10:00 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Count with multiple conditions

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Ah, sorry if that confused you. I have a habit of breaking long formulas into multiple lines (ALT+ENTER) at logical points so that I find them easier to read.

Code:

=IF(ISNUMBER(MATCH($K$2,$B$1:$H$1,0)),COUNTIF(INDEX($B$2:$H$10,,MATCH($K$2,$B$1:$H$1,0)),J3))
    +IF(ISNUMBER(MATCH($K$2,$A$2:$A$10,0)),COUNTIF(INDEX($B$2:$H$10,MATCH($K$2,$A$2:$A$10,0),0),J3))

Glad you've got it sorted now.

Tags

count, index, lookup

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word count question	Wuffybrother	Word	3	03-22-2019 03:40 AM
Don't count hidden slides	Lu_Argentina	PowerPoint	0	10-12-2010 02:12 PM
Using Conditions to Add Values	EclipticalD	Excel	1	07-08-2010 09:50 PM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Don't count 0 in a chart	Rmaisone	Excel	0	08-21-2006 12:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:56 PM.