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.
Solved! Go to Solution.
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
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
There is no formula for your situation.
Just Add the lineitems and devide by no of line items