Using Sum if in summary field to add costs
I am trying to total up a budget value, if the submitted line is between correct dates, see below
=SUMIFS([TOTAL TRIAL COSTS]:[TOTAL TRIAL COSTS], [DATE SUBMITTED]:[DATE SUBMITTED], >=[BUDGET START]#, <= [BUDGET END]#)
but getting the #unparseable
Any help would be appreciated
Help Article Resources
Check out the Formula Handbook template!