# doing a sum based on day of the week

##### Board Regular
Column D has dates for one month in the format "mmm dd, yyyy - ddd" in cells D1, D2 ... D30:
Sept 01, 2007 - Sat
Sept 02, 2007 - Sun
.....
Sept 30, 2007 - Sun

Column E can have the values 0.25 or 0.5 or 0.75 or 1 for each day.

So cell E31 contains the total because it has SUM(E1:E30)
Simple and it works.

------------------------------------------------------------------------------------------

Now *UNDER* E31, I would like to have totals for each day of the week.

So Column D would then contain just the text:
Mon (in D32)
Tue (in D33)
Wed (in D34)
Thu (in D35)
Fri (in D36)
Sat (in D37)
Sun (in D38)

And the corresponding value under Column E would be:
the total for just the Mondays in cell E32
the total for just the Tuesdays in cell E33
....

So the question - can you help me create the formula for E32?
It should sum E1:E30 but ONLY if date in the corresponding D cell is a Monday.

Thanks.

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### Jonmo1

##### MrExcel MVP
This will give you monday.
=SUMPRODUCT((WEEKDAY(D\$1:D\$30)=2)*1,E\$1:E\$30)

the bolded 2 is the number to change to get different weekdays
2=Mon
3=Wed
4=Thur
etc...

##### Board Regular
Great. It helped. Thank you.

Replies
5
Views
389
Replies
4
Views
301
Replies
4
Views
305
Replies
6
Views
261
Replies
0
Views
867

1,191,166
Messages
5,985,051
Members
439,935
Latest member
Monty238

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back