Resolved >>> summing amounts corresponding to variable date ranges

[dzkgny]

Hello. I'm new to this forum.

Can someone help with formula which can sum Amounts from varying Weekly time periods and the result be recorded in the appropriate month? I'm stuck.
I've attached a simple example of the way the output needs to look and a sample data table below.
Any help is appreciated!

[Dean England]

dzkgny,

If I'm understanding you correctly, I think this is what you need. In D2 copied down and accross.

=SUMPRODUCT(--($A$11:$A$70>=$B2),--($A$11:$A$70<=$C2),--($B$11:$B$70=D$1),$C$11:$C$70)

if you want the week numbers in Col B & C included.

=SUMPRODUCT(--($A$11:$A$70>$B2),--($A$11:$A$70<$C2),--($B$11:$B$70=D$1),$C$11:$C$70)

if you only want the weeks between Col B & C. Hopefully, one of these is what you want.

Dean

[oldchippy]

Or this in D2, then drag down and across

=SUMPRODUCT(--($A$11:$A$70>=$B2)*(--($A$11:$A$70<=$C2)*(--($B$11:$B$70=D$1)*(--($C$11:$C$70)))))

[dzkgny]

This worked great. Thanks!