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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies