Write some Software

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.

Compétences : Excel, Architecture Logicielle

en voir plus : email sample invoice attached, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, write introductory email sample, software write books, software write protection, registration confirmation email sample, free software write book, software engineer cover letter sample, software write book, microsoftofficeinteropoutlookapplication send email sample, srs software requirement specification gps sample, send email sample password, write part email autoresponder series, write simple email backup script, write newspaper article sample, software write protect software, promotional email sample

Concernant l'employeur :
( 276 commentaires ) CHICAGO, United States

Nº du projet : #12690220

Décerné à:

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(320 Commentaires)

6 freelance font une offre moyenne de $69 pour ce travail


%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(120 Commentaires)

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(99 Commentaires)

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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(50 Commentaires)

Hi there, I am a student who is currently trying to make some money on the side of school. I have lots of experience working with excel and I am very organized and I can work quickly. I am just looking for simple proje Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

I'm Microsoft Office Teacher in a University, I have Certified Microsoft Office Specialist, excel expert, word expert, powerpoint expert

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)