Thanks:  0
Likes:  0

# Thread: Sum values per day

1. Thanks Mark and Yogi, I have learned a lot.

2. ## 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:-
 Monday 1000 Tuesday 2000 Wednesday Thursday 3000 Friday 1500 Saturday 2000 Sunday 4000

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. ## Re: Sum values per day

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

4. ## 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. ## Re: Sum values per day

Originally Posted by Dave Patton
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.

## User Tag List

#### Posting Permissions

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