+ Reply to Thread
Results 1 to 6 of 6

Average weekday revenue (Google Sheets)

  1. #1
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Average weekday revenue (Google Sheets)

    I have the following data at https://docs.google.com/a/advantagep...#gid=780088323

    I'm trying to figure out the average daily revenue. Range L4:L34 would give the total growth. I just need to find a way to find the average based on the amount of weekdays occurred during this month. Not any future weekdays. For example, if L4:L34 was sum of $10,000 and there were 9 weekdays it should return $1,111.12. I figured this formula

    Please Login or Register  to view this content.
    to count weekdays in my I4:I34 range. I just need to figure out a way so it doesn't include future dates. Just ones which have already occurred in the current month.

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Average weekday revenue (Google Sheets)

    =COUNTIF($I$4:$I$34,"Monday")+COUNTIF($I$4:$I$34,"Tuesday")+COUNTIF($I$4:$I$34,"Wednesday")+COUNTIF($I$4:$I$34,"Thursday")+COUNTIF($I$4:$I$34,"Friday")

    Or


    =SUM(COUNTIF($I$4:$I$34,"Monday"),COUNTIF($I$4:$I$34,"Tuesday"),COUNTIF($I$4:$I$34,"Wednesday"),COUNTIF($I$4:$I$34,"Thursday"),COUNTIF($I$4:$I$34,"Friday"))



    With a SUM you separate the values to be added with commas, not plus signs.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Average weekday revenue (Google Sheets)

    could make it a countifs() where the second criteria range is $J$4:J$34 and the criteria is "<="&today()

    p.s. this is actually my first time using google docs for anything... I like a lot about it, like how well they make each component of a formula pop out... but it feels really clunky... is that just me?

    p.p.s. i'm pretty sure you should be able to see my change listed as "anonymous" ... correct?
    Last edited by simarui; 08-07-2014 at 03:43 PM.

  4. #4
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Re: Average weekday revenue (Google Sheets)

    Quote Originally Posted by simarui View Post
    could make it a countifs() where the second criteria range is $J$4:J$34 and the criteria is "<="&today()

    p.s. this is actually my first time using google docs for anything... I like a lot about it, like how well they make each component of a formula pop out... but it feels really clunky... is that just me?

    p.p.s. i'm pretty sure you should be able to see my change listed as "anonymous" ... correct?
    Excel is more robust overall but I prefer Google Sheets because it's very mobile and I like using Chromebooks. Google Sheets can chug on less powerful computers but I use the Acer C720 with the 4GB memory and it files. Moreso even than some of my older Windows 7 workstations.
    Last edited by djarcadian; 08-07-2014 at 04:41 PM.

  5. #5
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Average weekday revenue (Google Sheets)

    sweet. did the countifs() formula I added address your issue?

  6. #6
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Re: Average weekday revenue (Google Sheets)

    Quote Originally Posted by simarui View Post
    sweet. did the countifs() formula I added address your issue?
    Yes, thank you. It did the trick. I added to your reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting the average revenue per client by month
    By mkestian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2014, 09:49 AM
  2. Average If Weekday
    By freud1 in forum Excel General
    Replies: 3
    Last Post: 07-08-2011, 05:09 AM
  3. average based on weekday
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 09-06-2005, 04:05 AM
  4. average based on weekday
    By Nick in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. average based on weekday
    By Nick in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1