Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Average including blank days

0

Hi all

Is there a way to calculate the average for a column including days for zero days.

I've attached my file.

Thanks

Albert

excelvlookupdata-analysisfinance
MS Office Version: 2019
posted by: wildecoyote1966 (rep: 30) on Wed Dec 15, 2021 at 5:08 pm
Answer
Discuss

Answers

0
Selected Answer

Albert

The average is the sum of a bunch of numbers divided by the count of same.

If you want to count the numbers (including zeroes) but ignore the blanks (or yet to be completed cells) you can use:

=COUNTA(B4:B174)
Just use that as the divisor in the formula:
=SUM(B4:B174)/COUNTA(B4:B174)
Hope this helps.
posted by: John_Ru (rep: 6152) on Wed Dec 15, 2021 at 6:20 pm
Discuss

Discussion

Thanks John
wildecoyote1966 (rep: 30) Dec 16, '21 at 6:37 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login