“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

use a countif, averageif and excel if else to calculate the number of breeds

Solved by A. J. in 16 mins

In cell H2, use the AVERAGEIFS function to calculate the average cost of attendance (Res_COA) for colleges in the State of Kansas that have a low cost of attendance. To ensure that you only calculate the average for the lowest-cost schools, you decide to only average schools that earned a 5 Cost point value in Column N.
Hint: Be sure to use range names when creating the formula.

Solved by C. D. in 28 mins

Internal Rate of Return (IRR) Calculator
I need a calculator to determine an Internal Rate of Return (IRR). calculates the IRR on an annual basis of an irregular stream of 15 payments.

Solved by M. E. in 25 mins

Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column. Correct the function used in cell A4 to count the number of values in the Street column. Correct the function used in cell A5 to count the number of blank cells in the NumAttending column.
Correct the function used in cell A6 to display the largest value in the NumAttending column.
Correct the function used in cell A7 to display the average value in the NumAttending column.

Solved by F. C. in 22 mins