|
|
#1
11-08-2012, 02:26 AM
|
|||
|
|||
Countifs and Sumproduct
Can Countifs and Sumproduct work together?
I have a column I4:I80. In this column, all the cells have either text "NF" or "F". Some of these cells are coloured light grey and some are not. I want to have a formula that will count the number of NF or F that are only in the light grey cells. This is the formula I used for counting the number of "F" : =countifs(I4:I80,"=F", I4:I80,"=sumproduct(--(colorindex(I4:I80)=colorindex(I87)))") I87 is the cell where I have the light grey colour highlighted for reference. Why does the formula return a 0 (zero) for both NF and F? (I have 20 NF and 8 F in light grey coloured cells.) Attached is the function for colorindex. Can anyone help? Thank you 
Last edited by Algo; 11-08-2012 at 05:14 AM. Reason: Mistake in the above countifs formula 
|
| 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
Threaded Mode