Home

COUNTIFS and AVERAGEIF not working. What am I doing wrong?

jeremys78
New Contributor

As you can see in the COUNTIFS screenshot, it's returning a zero (0), but there is clearly one (1) cell that meets the criteria. And, in the AVERAGEIF screenshot, it's returning a Divide by Zero error. All the formulas down the L and M columns are consistent and the workbook is started from new/scratch so there is nothing in the background that might be interfering because it is not Save As'd from anything. Everything I've found on the internet says those formulas should work. The Averages by Day of the Week formulas works great. For some reason, these formulas are not liking times. I even tried formatting all the times as text and it still wouldn't work.

2 Replies

@jeremys78 , criteria syntax is ">"&J3, etc. And AVERAGIFS for two criteria.

You da man. It worked. Thanks
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies