I have a table with a column that can take on values:
Although I think the SUMIFS() formula is attempting to evaluate the greater/less than conditions, I still want to utilise it to get the sums for each group. Here's what I'm attempting:
=SUMIFS( AP[item_balance], AP[days_late_category], "'<30'")
I tried using single quotes inside the double quotes, but that didn't work : "'<30'" and "'>90'".
Is there a way to calculate this?