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.
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.
There is no formula for your situation.
Just Add the lineitems and devide by no of line items0
Create a "Count =1" line, and instead of divide by 4, you divide by the sum of the "Count =1" line.0