Averaging Invoice Totals

Rick Byers

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!

David Tutwiler

I think a COLLECT will fix this for you. So something like:

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

Here there the Collect asks for the range to be collected (the invoice total) and then follows by asking the Criteria Range then the Criteria to match to.

I think this should work.

David Tutwiler

I think a COLLECT will fix this for you. So something like:

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

Here there the Collect asks for the range to be collected (the invoice total) and then follows by asking the Criteria Range then the Criteria to match to.

I think this should work.

Rick Byers

That did the trick! Thanks David!

David Tutwiler

Awesome! Glad it is working.