Looping

[LaDdIe]

Hi,

Col A contains dates "dd/mm/yyyy"
Col B Contains values

C1 is a variable month number 1-12
D1 is a variable year

I need E1 to sum all values in Col B that match the coresponding date of
Col A based on the criteria set in C1 & D1.

Thanks.

LaDdIe

 

[Mike H]

Try this

=SUMPRODUCT((MONTH(A1:A20)=C1)*(YEAR(A1:A20)=D1)*(B1:B20))

Mike

 

[Lars-Åke Aspelin]

Hi,

Col A contains dates "dd/mm/yyyy"
Col B Contains values

C1 is a variable month number 1-12
D1 is a variable year

I need E1 to sum all values in Col B that match the coresponding date of
Col A based on the criteria set in C1 & D1.

Thanks.

LaDdIe

Try this formula in cell E1:

=SUMPRODUCT((YEAR(A1:A10)=D1)*(MONTH(A1:A10)=C1)*(B1:B10))

Change the 10 in three place to cover then number of rows with data in
columns A and B.

Hope this helps / Lars-Åke

 

[LaDdIe]

Thanks