What is Unparseable about this formula?

bhsiao_regcorp

=SUMIFS({Daily Sales Tracking Range 5}, {Daily Sales Tracking Range 2}, >=[Week Start]@row, {Daily Sales Tracking Range 2}, <=[Week End]@row, {Daily Sales Tracking Range 4}, IF(CONTAINS("Better", [{Daily Sales Tracking Range 4}]:[{Daily Sales Tracking Range 4}])))

Nick Korna

Hi @bhsiao_regcorp,

You need some @cell references in there (assuming your cross sheet ranges are OK):

=SUMIFS({Daily Sales Tracking Range 5}, {Daily Sales Tracking Range 2}, @cell >= [Week Start]@row, {Daily Sales Tracking Range 2}, @cell <= [Week End]@row, {Daily Sales Tracking Range 4}, CONTAINS("Better", @cell))

This should hopefully take the SUM of the rows within the column that is Range 5 where all the following conditions are met:

Range 2 is equal to/great than the date in Week Start (assuming both are date for column type).

Range 2 is equal to/less than the date in Week End (as above).

Range 4's row contains "Better" (note that this just checks the word is there, so if it is it part of a sentence it will be found).

Hope this helps, but if you have any problems/questions then just ask! 🙂

bhsiao_regcorp

Thank you!