“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How to average sum per person in excel. I need assistant

Solved by M. A. in 16 mins

i have a pivot with 2 calculated fields, 1 is set as sum and 1 is set as average. i know what to create another calculated field to calculate =calculated field 1 (sum) -calculated field 1 (average). i've tried this, but it is calculating the average field as if it is a sum. for example 2%-10%(average)= should equal -8%, but it is calculating 2%-30% (sum) -28%. hope that makes sense?

Solved by X. J. in 19 mins

Hi,
I am having trouble finding the average of a sum.

Solved by I. H. in 19 mins

I need help writing a formula using sum product for weighted average

Solved by I. Q. in 16 mins

in PIVOT TABLE AVERAGE IS NEEDED BUT SUM IS COMING. CANT FIND HOW TO SOLVE

Solved by A. A. in 30 mins