Forum Discussion
Excel 2016 formula help
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 ...
The AVERAGEIF and AVERAGEIFS functions ignore blank cells.
=AVERAGEIFS(C21:HI21,C3:HI3,"Mon")