|
|
|
|
#1
11-13-2012, 05:48 AM
|
|||
|
|||
Countifs and Sumproduct
Hi Catalin B. I agree with you and Macropod that "=SUMPRODUCT(--(colorindex(A6:A25)=colorindex(D6))" will not give a result as a number in this case. Hence I made changes so that "Sumproduct" need not be used. Attached is the same file with the changes made.
Thanks for all the suggestions given. 
|
|
| 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 Vista 
Office 2007
Hybrid Mode