Guys, the formula below seems to be calculating only the number of cells with "P1" in it.
Don't let the long formula scare you off... I'm just wanting to find the number of times a cell in column F is either yellow or red when column A has a "P1" in it.
The underlined portion of this formula works... so I just need to get it to only count when P1 is in column A
=COUNT(('Dashboard'!A9:A384="P1")*(SUMPRODUCT(--(ColorIndexOfRange('Dashboard'!$F$9:$F$384,FALSE,2)=COLORINDEXOFONECELL('Dashboard'!$A$3,FALSE,2))))+(SUMPRODUCT(--(ColorIndexOfRange('Dashboard'!$F$9:$F$384,FALSE,2)=COLORINDEXOFONECELL('Dashboard'!$A$5,FALSE,2)))))
When I use the formula, if a cell in column F is yellow or red it gives me 34 (total # of cells with a "P1") as an answer
Appreciate your time and help.
Matt
Bookmarks