Hi there, I have input this formula into my spreadsheet and it has come back with #VALUE!
Can anyone see why?


=SUMPRODUCT((Data!N2:N210>=DATE(2014,4,1))*(Data!N2:N210<=DATE(2014,6,30))*(Data!P2:P210=1)*(Data!O2:O210 >3))