average with values

%3CLINGO-SUB%20id%3D%22lingo-sub-2660147%22%20slang%3D%22en-US%22%3Eaverage%20with%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660147%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everybody%2C%3CBR%20%2F%3EI%20would%20like%20to%20apply%20the%20average%20to%20be%20calculated%20on%20a%20row%20to%20a%20cell.%20The%20average%20should%20be%20calculated%20only%20on%20cells%20with%20value%20excluding%20those%20with%20value%200%20or%20%22-%22%20which%20should%20not%20be%20counted.%3CBR%20%2F%3ESuggestions%3F%3CBR%20%2F%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2660147%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-2660174%22%20slang%3D%22en-US%22%3ERe%3A%20average%20with%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131253%22%20target%3D%22_blank%22%3E%40ilVale10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20good%20site%20for%20you%20to%20know%20about....you%20can%20research%20basic%20questions%20like%20the%20one%20you've%20asked%20and%20generally%20find%20your%20own%20answer.%20Here%2C%20for%20example%2C%20is%20a%20link%20to%20the%20answer%20to%20your%20question%2C%20which%20I%20arrived%20at%20after%20just%20entering%20the%20word%20%22average%22%20in%20their%20search%20window%20and%20reading%20and%20following%20links%20within%20(there%20are%20lots%20of%20Excel%20variations%20on%20%22AVERAGE%22%20and%20it%20turns%20out%20that%20%3CSTRONG%3EAVERAGEIFS%3C%2FSTRONG%3E%20is%20what%20you're%20looking%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-averageifs-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-averageifs-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everybody,
I would like to apply the average to be calculated on a row to a cell. The average should be calculated only on cells with value excluding those with value 0 or "-" which should not be counted.
Suggestions?
Thank you

2 Replies

@ilVale10 

 

Here's a good site for you to know about....you can research basic questions like the one you've asked and generally find your own answer. Here, for example, is a link to the answer to your question, which I arrived at after just entering the word "average" in their search window and reading and following links within (there are lots of Excel variations on "AVERAGE" and it turns out that AVERAGEIFS is what you're looking for.

 

https://exceljet.net/excel-functions/excel-averageifs-function

 

Thank you very much @mathetes