Google Product Forums
Range till last value in a row
Hoopsnl Jun 27, 2012 1:51 AM
Posted in group: Google Docs

Categories: Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :

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 and Q are filled until row 360, I use 499 because the form is filled in daily and I want to Array to take it all.
Is there also a option that tkaes the range till the last filled in row ? Instead of 'Sheet'!$C$4:$C$499 something like 'Sheet'!$C$4:$C$LastFilled ?

I hope someone can help,

thx