How do I get the average of a line item?

I have Line Item A, Line Item B, Line Item C, and Line Item D. How do I get the average of those line items? I know I could add them and divide 4 but I was wondering if there was a formula? I tried the average formula but I don't think it works in this case.

Best Answer

  • @zdlee 

    Sum all the line items and divide it by the number of line items. This is the only way we have to find the average of the line items.

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

  • There is no formula for your situation.

    Just Add the lineitems and devide by no of line items

  • Create a "Count =1" line, and instead of divide by 4, you divide by the sum of the "Count =1" line.