Averaging Invoice Totals

I am trying to AVG invoice totals by "Invoice Description" and "Packaging Description". So, I am trying to determine the average Invoice Total for "Plates" and "Body", "Plates" and "Lid", etc. Here's an example of my columns I am using to determine the averages:

My formula is as follows but is not calculating properly:

=AVG({Packaging Invoices Range 1}, "Plates", {Packaging Invoices Range 3}, "Body", {Packaging Invoices Range 2})

Range 1= Invoice Description

Range 2 = Invoice Total

Range 3 = Packaging Description

Thanks for your help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!