| Range till last value in a row | Hoopsnl | 6/27/12 1:51 AM | I have used following script for a while now; =ArrayFormula(sumproduct((month('Sheet'!$C$4:$C$499)=A35)*(year('Sheet'!$C$4:$C$499)=$B$34)*('Sheet'!$Q$4:$Q$499))) It worked always fine until now, I get following error: "Argument is empty" Column C |
| Re: Range till last value in a row | APL+ | 6/27/12 2:05 AM | Hi, the behaviour of YEAR() and MONTH() has changed, the long answer is here. The short answer is to wrap the YEAR() and MONTH() functions in IFERROR(). =ArrayFormula(sumproduct((IFERROR(month('Sheet'!$C$4:$C$499))=A35)*(IFERROR(year('Sheet'!$C$4:$C$ |
| Re: Range till last value in a row | Hoopsnl | 6/27/12 2:24 AM | Thanks APL+ for your swift answer and solution! It worked for me, you are great!!! |