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

How do I compute the sum or an average of a column with 5000+ rows when some of the cells have #N/A N/A values? I would like any function (average for instance) to ignore those lines. Can you please help?

Solved by G. B. in 19 mins

hello, I need help calculating the average revenue for every quarters can you please help me

Solved by A. H. in 18 mins

How can I calculate the standard deviation for an average in a pivot table?

Solved by C. B. in 22 mins

Can you take the average of a list of numbers one of the values is <10?

Solved by E. F. in 12 mins

Hi I'm stuck with a pivot chart trying to calculate the average of mistakes per area. I have the chart to that point. per week and area and shows bar for total amount and total mistakes per area and an average of those mistakes base on totals per area. I will like to show an overall average. For example if I filter for a week for all areas that I can see the average per area and the overall average. please help.

Solved by K. D. in 18 mins