Summing values from range with if statement

Hey all!

I am new to this forum, because I have been able to solve my problem by my self so far, but now I have met an impossible problem.

The problem is following:

I have 31 dates on cells from D7 to D37, lets say for example 1.1-31.1.
On sheets from E7 to E37 I have amount of hours, i have worked on a current day.

What I would like to have is a function, which sums all the hours together that have been done on Monday from the range E7:37. I have tried following on a cell: =sumif(D7:D37;WEEKDAY(2);E7:E37).
I know how I could do it with a fill function and then sum those together, but in that case I would have 32 different cells needed to do the trick.

Could anyone help me, I am desperate because excel has won me

Cheers,

Tuomas/Finland

Well first off, what you have in D7:D37 (1.1-31.1) are not real dates so in the current format does not seem possible.

Do you want to show a sample Excel file of what you have?

Hey,

I know that they are not real dates, but this is the only way I knew to get them automatically appear and I do not have to input manually dates and weekdays.
Here you can see the attachment file, dates are in Finnish but the formulas are in English.

Hope you get a clue

Hey,

This is all most the thing I was looking for. Only problem is, that the days you have written "monday, tuesday.." on C7:C37, I take them from the dates on C8:C38 with custom format DDDD.
Therefore I can not the same formula than you, where you use days(G8:G13) as reference.

I use this style, because then it automatically takes right dates and day numbers to all my month sheets(jan to dec).

So in short, is there a way that I could use the "workday(2), workday(3.." as reference to sum the done hours?

Sorry for the bad explaining and thanks very much for the super fast reply!

Brg,

Tuomas

How about...

=SUMPRODUCT(--(TEXT($D$7:$D$37,"ddd")="Mon"),$E$7:$E$37)

Change the day as needed or you can put the day in a cell and reference it...

=SUMPRODUCT(--(TEXT($D$7:$D$37,"ddd")=$G$1),$E$7:$E$37)

Note: Sorry about that, if those are the days in M10:M15, then seems Vince has it...

OK, I think I got it... see modified version of your sheet.

- Vince

* Note
- The changes were made on the sheet named 'Helmikuu' which I assume means February in Finnish?
- I changed the formulas in column C from '=D12' to '=TEXT(D12,"dddd") to get it to function properly.
- I changed the formulas in column N to '=SUMIF($C$7:$C$37,"Monday",$E$7:$E$37)', changing for each day of the week.