View Single Post
 
Old 02-22-2011, 10:00 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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