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

Symbol Last Sale Price Rank
CITI BioPharma Corp. $4.56 4
Apple Inc. $190.99 1
Citigroup Inc. $68.20 2
Bank of America Corp. $28.86 3
Average Value >100
I need to use the AVERAGEIF function to calculate the average value of these stocks for less than $100.00 using the criteria >100.

Solved by Z. Y. in 13 mins

In the current cell, use the average function to calculate the average quarterly revenue for the fiscal year ( do not use the insert function wizard

Solved by X. B. in 23 mins

average if function correction for mod 8

Solved by G. E. in 11 mins

Why is my average value for my total hours/day column showing the wrong value. I used the average formula to take the average off all the rows.

Solved by M. H. in 30 mins

I am trying to use the excel function AVERAGE for four data slots. When I use the function, it is not taking the average, but instead just leaving me with the four terms added together.

Solved by M. B. in 17 mins