Find the average of a row by color

[davidgriffith1234]

Hi there,

I hoping for some help with my problem. I am looking for a quick way to find the average of a row of numbers by there color.

I need to find the average of only the green and red cells (ignoring the white and blue cells) without having to select each cell individually.

Any help would be greatly appreciated.

Thanks

David

[Bernie Deitrick]

You basically need to replicate your two different CF conditions into one logical analysis

((>=6 AND <=219) OR (>=260))

using SUMIFS and COUNTIFS, like this for row 1:

=IFERROR((SUMIFS(A1:S1,A1:S1,">=6",A1:S1,"<=219")+SUMIFS(A1:S1,A1:S1,">=260"))/(COUNTIFS(A1:S1,">=6",A1:S1,"<=219")+COUNTIFS(A1:S1,">=260")),"")

The single condition >=260 doesn't require the S versions of SUMIF and COUNTIF but it is still OK to use.