Forum Discussion
Zaidee
Jan 28, 2021Copper Contributor
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 having any luck. Can someone help please?
1 Reply
The AVERAGEIF and AVERAGEIFS functions ignore blank cells.
=AVERAGEIFS(C21:HI21,C3:HI3,"Mon")