sumproduct over multiple sheets and between two dates

[Alwinaz]

Hi there

I have the following formula on sheet1 =SUMPRODUCT((Mariska!H3:H36>=Sheet1!C1)*(Mariska!H3:H36<=Sheet1!E1)*Mariska!L3:L59)

What i am trying to do is to sum column L on the sheet named Mariska if the date in column H (sheet mariska) is >= date in C1(sheet1) and <= E1. with the current formula i get a #N/A.

Any suggestions on what i am doing wrong?

 

[XOR LX]

Hi,

Your ranges need to be the same size. You currently have two going to row 36 and one to row 59.

Regards

 

[Alwinaz]

Thanks XOR LX. Problem solved!

 

[XOR LX]

You're welcome.