I tried to use sumif to sum up values of cells in a row below cells
highlighted with interior colorfilled:

sumif(range1, interior.colorindex=3,range2)

range 1 - row with highlighted cells
interior fill color - red
range 2 - cells in row below containing values to be summed up

the formula returned 0 value.

Anyone who can shed some light?