|
|
#5
02-22-2011, 10:00 AM
|
||||
|
||||
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))
|
| Tags |
| count, index, lookup |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode