SOLVED

Excel Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2382546%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382546%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Everyone%2C%26nbsp%3B%20need%20help%20with%20another%20formula.%26nbsp%3B%20not%20sure%20why%20i%20cant%20figure%20this%20out%20but%20any%20help%20is%20appreciated.%26nbsp%3B%20what%20im%20trying%20to%20do%20is%20gather%20an%20average%20percentage%20but%20some%20cells%20there%20isnt%20any%20data%20inputted%20and%20showing%20a%200%25%2C%20but%20average%20function%20is%20calculating%20the%200's.%26nbsp%3B%20in%20the%20top%20right%20corner%20of%20the%20spreadsheet%20i%20want%20the%20formula%20put%20in%20cell%20W5%20under%20%22Yearly%20LFM%20Avg.%22%20and%20calculate%20the%20data%20while%20ignoring%20the%200's.%26nbsp%3B%20the%20data%20is%20coming%20from%20Row%209A-9AA%20next%20to%20%22Chamise%20Avg.%22%26nbsp%3B%20the%20spreadsheet%20is%20attached%20below.%26nbsp%3B%20thanks%20for%20any%20and%20all%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2382546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2382612%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382612%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F289214%22%20target%3D%22_blank%22%3E%40spalmer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20the%20attached%20Sheet%2C%20I've%20suggested%20two%20different%20formula%20are%20in%20RED%2C%2C%20solves%20the%20issue.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2384846%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2384846%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much%20Rajesh!%20that%20worked!%20really%20appreciate%20your%20time%3C%2FLINGO-BODY%3E
Contributor

Hey Everyone,  need help with another formula.  not sure why i cant figure this out but any help is appreciated.  what im trying to do is gather an average percentage but some cells there isnt any data inputted and showing a 0%, but average function is calculating the 0's.  in the top right corner of the spreadsheet i want the formula put in cell W5 under "Yearly LFM Avg." and calculate the data while ignoring the 0's.  the data is coming from Row 9A-9AA next to "Chamise Avg."  the spreadsheet is attached below.  thanks for any and all help

3 Replies
best response confirmed by spalmer (Contributor)
Solution

@spalmer 

 

Check the attached Sheet, I've suggested two different formula are in RED,, solves the issue. 

Thank you very much Rajesh! that worked! really appreciate your time
Glad to help you ,, since what I've suggested is working for you then you may accept it as Best Answer as well Like,,, and keep asking ☺