Excel 2016 formula help

[Zaidee]

I have three following formula =SUMIFS(C21:HI21,C3:HI3,"Mon")/COUNTIFS(C3:HI3,"Mon"). Some of my "Mon" columns are blank and I need the formula to ignore them. I have tried several options and am not having any luck. Can someone help please?

[#2]

@Zaidee 

The AVERAGEIF and AVERAGEIFS functions ignore blank cells.

=AVERAGEIFS(C21:HI21,C3:HI3,"Mon")