# excel file to calcuate average for different sheet

I need to calculate average formula

problem is if sheet is blank or zero i do not want to include in average

u can see sample file

=AVERAGE(VLOOKUP(A4,'day1'!\$A\$1:\$C\$6,3,0),VLOOKUP(A4,'day2'!\$A\$1:\$C\$6,3,0),VLOOKUP(A4,'day3'!\$A\$1:\$C\$6,3,0))

Beceriler: Excel, Matematik, Visual Basic

İşveren Hakkında:
( 34 değerlendirme ) mumbai, India

Proje NO: #21345031

## Seçilen:

CSEI

Hello Sir/Madam, you mean to say black cell if you answer is yes. The solution to your problem is simple "if" function, please give me a chance to prove it. Hope I can work for you I work most of the time with excel Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% INR
(0 Değerlendirme)
0.0

## Bu iş için 24 freelancer ortalamada ₹873 teklif veriyor

TonmoyRoy111

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(325 Değerlendirme)
6.8
younus15

Hi there. I checked tosolve worksheet. I can do your project in less than 24 hour according to your description with full delivery and without error. I would also complete your project with the highest precision and qu Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(109 Değerlendirme)
5.9
AnowarRatul

INR 600 Only ------- In just 30 Minutes ------- Excel VBA Macro & Formula Expert ------- 100% satisfaction first, then payment.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(23 Değerlendirme)
3.6
hkh581e5c8f1cb8a

Hi there! Am a professional accountant in KSA, who have 6+ years of experience. With high MS excel and financial management knowledge. I can provide you free samples with high quality and in a fair price. Please, feel Daha Fazla

₹1050 INR in 7 gün içinde
(7 Değerlendirme)
2.8
mowachira77

Hi. I am excel expert and I am available to work on your excel work. I will write a formula or VBA if you wish. I will finish this work in a matter of hours. Thanks in advance.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(7 Değerlendirme)
3.1
coopernowitzki

Hello. I am an English speaking American. I have taken a look at your Excel file and I see that you're building an average value in the summary sheet based on VLOOKUPs from the other 3 sheets that have the same value i Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(3 Değerlendirme)
2.7
samobot

Its just a matter of few formulas tweaking and I can do it for you in 10 minutes. "I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at captur Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(5 Değerlendirme)
2.5
Panggumsok

Hi, I do some work in excel work using excel formula and macro. Working with me will may save your money and time. I can start work just right now. I hope your kind contact on this project. Thanks!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(1 Yorum)
1.0
ArunTindu

Dear Client, By seeing your job description, I wish to work for it. Could you please elaborate it? I have some queries to clarify with you. I can able to help you to calculate and get the required final output. Good s Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(2 Değerlendirme)
1.0
sunanda31b

Hii, I can do it quickly as per the need. Well versed with advance excel. Relevant Skills and Experience My day to day working is data based.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
vikash404

Hello Sir, I can complete your excel file work which involves calculating average formula. I can start to work now.\ Please review my bid Regards, Vikash

₹900 INR in 3 gün içinde
(0 Değerlendirme)
0.0
AzliezaIsmail

hi i'm azlieza . i'm expert in excel and have many experience in calculate average in excel. in this case i can solve your problem and makes you have a very good result.

₹1050 INR in 7 gün içinde
(0 Değerlendirme)
0.0
polite90

Hi, I am a senior software developer. I have rich experience with excel, vba. I can do it perfectly. thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
abasem471

I have experience in the same field Relevant Skills and Experience I have good experience in spread sheet excel

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
shubhamtapase53

Hello, I am interested for your project. I read your description, I will do that work accurately. I am expert in Excel and I am Engineering student so my math is very good. I have completed such type of task in my care Daha Fazla

₹750 INR in 3 gün içinde
(0 Değerlendirme)
0.0
Anasmicano

I can do your project immediately ,l have more skills and experience qualify me to finish your project before the deadline and with good quality

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
roderichalayon

Hello! I can help you with your requirement. I have experience working on tasks like this and I'm used to solve this kind of issues. Regards!

₹600 INR in 7 gün içinde
(0 Değerlendirme)
0.0
uxiaojuan2019

I have been working as a typist and developer with python, Java, office, vb, c, c++,web programs for 7+ years. In these years, I have many experiences in these branches.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
tamaratriardilla

I can solve this problem, so just hire me. I will wait your text. Just send me your file include problem to solve.

₹600 INR in 3 gün içinde
(0 Değerlendirme)
0.0
Hismasterpiece

Hi client, I have gone through the attached file and i can do the job within the shortest period of time.I have done such works in the past and has completed each project successfully and on time. You can contact me Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0