D
Danny Boy
I saw this formula on Chip Pearson's site. According to Chip:
You can use the ColorIndexOfRange function to get the sum of the values in
those cells whose color index is some specified value. For example, the
following array formula will sum the values of the cells in range B11:B17
whose fill color is red.
=SUM(B11:B17*(COLORINDEXOFRANGE(B11:B17,FALSE,1)=3))
I tried to use this formula in a spreadsheet, but received a#NAME? error.
I'm trying to count all occurences in a range of cells that are in red font,
but I'm not having much luck.
You can use the ColorIndexOfRange function to get the sum of the values in
those cells whose color index is some specified value. For example, the
following array formula will sum the values of the cells in range B11:B17
whose fill color is red.
=SUM(B11:B17*(COLORINDEXOFRANGE(B11:B17,FALSE,1)=3))
I tried to use this formula in a spreadsheet, but received a#NAME? error.
I'm trying to count all occurences in a range of cells that are in red font,
but I'm not having much luck.