Google Spreadsheet SUMPRODUCT with dynamic row count.

Hi I'm using this formula to add all items from a specific category and a specific date range.  But the problem I'm facing now is that I have another sheet where I insert all my entries, and this sheet dosen't have a max row, it can grow continuously, but in the formula I Inserted the range until A1000, but there could have more lines of code, how can I go around to put a dynamic row count on the formula.

=SUMPRODUCT(Entries!$F$3:$F$1000 * (Entries!$A$3:$A$1000 >= DATE(2015;COLUMN()-1;1)) * (Entries!$A$3:$A$1000 < DATE(2015;COLUMN();1)) * (Entries!$C$3:$C$1000 = A3))

Open in new window

Who is Participating?
barry houdiniConnect With a Mentor Commented:
I think SUMIFS would be preferable - you can use whole column range without any major downside


regards, barry
cinco-pata5Author Commented:
Perfect it worked great.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.