•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
averageifs formula does not work
Hello,
I need help because I am using an AVERAGEIFS formula in cell R8 to derive the mm:ss averages of column P using column 0 as a reference between the hours of 7 and 8. This is giving me a #DIV/0 error. Can anyone please advise?

[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#AVERAGEIFS
#formula
##DIV/0 error
#cell R8
#mm:ss averages
#column P
#column 0
#hours of 7 and 8
#error
#reference
#average
#help
#derive
#advice
#submitted
#comments