M any use Excel for basic tables, but you need to go beyond simple sums. If your formulas are getting clunky, conditional ...

XLOOKUP can also be used in conjunction with formulas such as SUM to retrieve certain items and add them up for a total value, which feels especially powerful when you're calculating separate values ...