Hey guys. Any help would be super appreciated. I'm kind of new to excel.
How could I do a formula that averages out total sums divided by input days.
Ex.
Monday: 100
Tuesday: 200
Wednesday: 300
Thursday
Friday
Saturday
Sunday
Daily Avg: 100 based on 3 input days
Ex.
Monday: 100
Tuesday : 200
Wednesday : 300
Thursday: 400
Friday: 500
Saturday
Sunday
Daily Avg: 100 based on 5 input days and so on.
Last edited by FDibbins; 07-29-2021 at 02:01 AM.
What do you want to calculate now? The average of 100+200+300 is 200 (600/3)
Messages have been translated from Dutch to English by means of google translate.
100 / 1 = 100. 200 / 2 = 100. 300 / 3 = 100
so if by the end of the week it's 700 / 7 = 100.
But I need it to update every day. does that make more sense? every input is a running total.
=max(range)/count(range)
Assuming your values are in the range B1 to B7, try this in cell C1 and copy it down.
=MAX(B$1:B1)/COUNTA(B$1:B1)
Still in #4. CountA() is different from Count()
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(I have changed it for you - this time)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks