I need someone to create two formulas for me in excel. The formulas deal with averages. For example I want the excel file to recognize a value of 0 within a cell to calculate the average. If a 0 is in a cell that I do NOT want to include that in the average. Here is an example:
1 + 2 + 3 + 4 = 10 [Average is 2.5 (10/4=2.5)]
1 + 2 + 3 + 0 = 6 [Average is 2 (6/3=2)]
1 + 2 + 0 + 0 = 3 [Average is 1.5 (3/2=1.5)]
4 + 0 + 0 + 0 = 4 [Average is 4 (4/1=4)]
Attached to this email is the sample excel file. The 4 values to calculate the average will come from cells C4:C7. The result of the calculation will need to be in cell C9.
Décerné à :
6 freelance ont fait une offre moyenne de 69 $ pour ce travail
Hello Jason! I can help you like I did in the past. I can complete this project in 1-2 days max. You will not be dissapointed, my rehire rate is 35%. Thank you!