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))
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))
Works for me.
Are you sure there is a date in column N, a number in columns O and P?
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
Ah, got it, I had a strange value in one of my columns!
That'll do it
Tip: You can use Data Validation to ensure invalid values can't be entered into cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks