Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Sum values per day

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Posts
    390
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Mark and Yogi, I have learned a lot.

  2. #12
    New Member
    Join Date
    Aug 2010
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum values per day

    Hi all,

    This thread is already so long ago, not sure if there's still anyone will reply..

    Anywayz.. is there any way for it to be:-

    1) Average the values for Weekdays (Monday to Friday) & with condition that there is a value for that weekday..

    Example:-
    Monday1000
    Tuesday2000
    Wednesday
    Thursday3000
    Friday1500
    Saturday2000
    Sunday4000


    For this example, the answer i want is 1875.
    But if i were to follow the method you gave earlier, the formula will give me an answer of 1500.

    Somebody pls help me!

  3. #13
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,430
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum values per day

    =AVERAGE(IF(A2:A8={"Monday","Tuesday","Wednesday","Thursday","Friday"},IF(B2:B8>0,B2:B8)))

  4. #14
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,430
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum values per day

    If Column A has real dates

    =AVERAGE(IF(WEEKDAY(A1:A100,2)<=5,IF(B1:B100>0,B1:B100)))

  5. #15
    New Member
    Join Date
    Aug 2010
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum values per day

    Quote Originally Posted by Dave Patton View Post
    If Column A has real dates

    =AVERAGE(IF(WEEKDAY(A1:A100,2)<=5,IF(B1:B100>0,B1:B100)))

    this is to use with Ctrl+Shift+Enter, right?

    Yeah.. it works! Thanks.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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