Hi there,

I have put this formula into my spreadsheet and it is coming back as 0, Ive stared at it for ages and can't see my mistake, could someone advise?

=SUMPRODUCT((Sheet1!Q2:Q199 >=DATE(2014,4,1)),(Sheet1!Q2:Q199 <=DATE(2014,6,30)),(Sheet1!Z2:Z199=1))

I am trying to calculate the number of "1"s occuring between 2 dates.

Thank you, I'm going mad!