I referenced a thread yesterday for this forum but I could not locate again today after giving it another go.
I found a thread that used some code to count the number of instances a cell has a certain background color using this formula: =SUMPRODUCT(--(ColorIndex(B5:B37,TRUE)=3))
Does anyone know how I can take it a step further and sum the numbers in the cells with that background fill?
Bookmarks