Thread: [Solved] Countifs and Sumproduct
View Single Post
 
Old 11-13-2012, 05:48 AM
Algo Algo is offline Windows Vista Office 2007
Novice
  
Join Date: Nov 2012
Posts: 3
Algo is on a distinguished road
Default 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.
Attached Files
File Type: xlsm countifssumproduct.xlsm (25.8 KB, 11 views)
Reply With Quote