I want to write a SUM if like function that says "SUMIF > than the value in Backlog column. So for instance I would like for everything in the backlog column greater than 56 to be SUM’d. If it is not greater than I would like to be able to leave out.
You can still use a GroupBy… Just put a Rule Engine prior to the groupby with:
$Column$ > 56 => “Sum”
$Column$ <= 56 => “Do not sum”
In your GroupBy, the column created by your Rule Engine will be your groups.
Of course, it will sum items with “Do not sum”, but you can just ignore that.
There may be a better solution, but it’s difficult to know without knowing how the data will be used further down the workstream. Hopefully this is a starting point.
Question on SUMIF came up a couple of times in the forum. @ipazin created an example for this and shared it in this thread: Sumifs Excel - #14 by ipazin