I have made a home budget spreadsheet where I got a main calendar view and tabs for 'Standing Orders', 'Income' and 'Expenses'.

In the main view I use a forumla that returns sum of all payments at given date from a Standing Orders tab, but when adds to it End Date criteria as a second criteria it gives #VALUE error.

Could You please point me in the right direction? Maybe I should use different fomula / combination of formulas?

My formula:

=-(SUMIFS('Standing orders'!$D$4:$D$16,'Standing orders'!$B$4:$B$16,DAY(D4),'Standing orders'!$E$4:$E$12,"<"&D4))

Screenshots: Standing Orders Tab Main View

New contributor
Robert Jamborski is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • 1
    Without trying your formula I can see that you have used unequal sized ranges. That wouldn't work. – JvdV Aug 12 at 16:37
  • Thank You a lot, that's the thing 😅 – Robert Jamborski Aug 12 at 19:40

Your Answer

Robert Jamborski is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.