Quote:
Originally Posted by Catalin.B
-use this formula: =SUM(IF((A6:A25="F")*(colorindex(A6:A25)=colorinde x(D6));1)) confirmed with CSE
-use this formula:
=COUNTIFS(A6:A25;"=F";C6:C25;colorindex(D6)), after you use in C6:C25 the formula colorindex(A6) copied down to extract the color index of range A6:A25
|
I guess you did not read the entire message, so your efforts are in vain...
I gave you a replacement for your formula that will do the job. It's the one in red, in case you don't read this message
11-13-2012, 07:44 AM
Similar Threads
Sumproduct formula
Windows Vista 
Office 2010 32bit
Hybrid Mode