How do I get the average of a line item?

zdlee_*66937
zdlee_*66937
in Modeling

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.

Tagged:

Best Answer

  • anand.shekhawat
    anand.shekhawat
    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

  • bhubeshrana
    bhubeshrana

    There is no formula for your situation.

    Just Add the lineitems and devide by no of line items

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

Categories