Ask Experts Questions for FREE Help !
Ask
    nurmala's Avatar
    nurmala Posts: 23, Reputation: 1
    New Member
    		  
    #1

    Nov 7, 2011, 07:11 PM
    Average function in MS Excel
    I have a set of numbers in MS Excel. I want to do the average function in column, but I do not want to include "0". Could anyone give me the function?

    Thanks indeed :)
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Nov 7, 2011, 11:56 PM
    What version of Excel are you using? If you're using Excel 2007+ then look at using the AVERAGEIF() function.
    nurmala's Avatar
    nurmala Posts: 23, Reputation: 1
    New Member
    		  
    #3

    Nov 8, 2011, 12:38 AM
    I`m using Excel 2003
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Nov 11, 2011, 08:34 AM
    Then something like:

    =SUMIF(A:A, ">0", A:A) / COUNTIF(A:A, ">0")
    nurmala's Avatar
    nurmala Posts: 23, Reputation: 1
    New Member
    		  
    #5

    Nov 12, 2011, 08:53 PM
    It works!! Thank you JBeaucaire :)
    nurmala's Avatar
    nurmala Posts: 23, Reputation: 1
    New Member
    		  
    #6

    Nov 16, 2011, 11:47 PM
    Hey, for Ms. Access, could you give the syntax please?

    Thanks
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #7

    Nov 17, 2011, 08:59 PM
    Sorry, I don't use Access.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel Function [ 2 Answers ]

I'm trying to figure out a way to Sum charges based upon date criteria and charge type criteria. Here's my problem. I keep a spreadsheet for personal finances. I use codes for different charges to easily sum and keep track of categories. Here's what it would look like: Date ...

Excel If function using 2 worksheets [ 4 Answers ]

I am using Excel 2007. I have created a spreadsheet1 with a list of names and dates. The names and dates can be repeated. I have another spreadsheet 2 with names and formulas. Here the names are not repeated. The formulas adjust the dates for aging purposes. If the name on Spreadsheet 1 equals...

Excel IF function [ 2 Answers ]

I am trying to run the IF function in excel against text rather numerical values. However it does not seem to want to process the argument. Is there a way to get this to work? Cheers

Excel function [ 1 Answers ]

I am looking for a formula that allows me to have a specific text if the value in the cell selected is between 19xx and 19yy. I thought of using IF but can't figure it out... :( If the value is greater than 1967 and less than 1977 value = 30s

Excel formula IF function [ 2 Answers ]

Hi. I am creaing a spreadsheet for work. Basically I have a column that shows all the project names, it shows a date and a price for the project. I need this price to then be automatically placed into the appropriate monthly column. I.e if the project is 20,000 and happened on the 21st of jan...

View more questions Search