|
|
#2
11-08-2012, 08:19 PM
|
||||
|
||||
It might make things easier if you could attach the workbook concerned, with some sample data (delete anything sensitive).
FWIW, it seems to me that, as coded, your formula couldn't possibly work, as: =countifs(I4:I80,"=F", I4:I80,"=sumproduct(--(colorindex(I4:I80)=colorindex(I87)))") says the third expression has to be, not the calculated result, but the literal string: "=sumproduct(--(colorindex(I4:I80)=colorindex(I87)))"
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| colorindex, countifs, sumproduct |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| sumproduct?? | jer | Excel | 9 | 10-14-2012 10:00 AM |
 Sumproduct formula
|
Portucale | Excel | 2 | 09-12-2012 10:51 AM |
| Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |
|
Sumproduct
|
angie.chang | Excel | 3 | 06-14-2012 10:00 AM |
| countifs? | sonyaturpin | Excel | 1 | 05-23-2012 08:29 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode