afternoon all,

its kindof a basic one but my formatting is well of as I am getting the normal "contains and error" message

I have a pivot table showing

Sum of Turnaround Days
count of Turnaround Days


and I want to add a calculated field of "sum of Turnaround days /count of turnaround days" and same for others.

=SUM('Sum of Turnaround Days' /'Count of Turnaround Days' )


Yet this is generating an error.


Without the "Sum of" excel defaults to count so I get "1".. (in all cases "sum of" is always larger than "count of" so I should always have a number great than 1).


any thoughts

steve