troubleshooting Question

How is it that I can get Excel Status Bar cell count but not average?

Avatar of garyrobbins
garyrobbinsFlag for United States of America asked on
Microsoft Excel
8 Comments1 Solution222 ViewsLast Modified:
Hello Experts.  I need your help regarding working with the Status Bar – Average function.

I have a spreadsheet created from a system export file.  The column titled time is formatted [h]:mm.  I can use the Excel Status Bar and view the cell count in the column but not the average or sum.  See attached sample file.  I’ve tried reformatting the original cells but doesn’t solve the problem.  What does change things is when I Edit each sell and simply exit the cell – the the average function works.

Any thoughts about how to work with data sheet which comes in each day?

Thanks,
Gary

Mikes-Report---Weekly-Hours---EE.xls
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros