Conditional Averages－software｜痞客邦

Jun 22 Fri 2007 20:37
Conditional Averages

close

I'm trying to calculate the average of ONLY the positive numbers from a
column of both positive and negative numbers. I'm sure there's an easy way
to do it, but everything I've tried hasn't worked. Any suggestions greatly
appreciated!

Kris

This is an array formula, meaning you commit it with Shift-Ctrl-Enter

=AVERAGE(IF(A1:A10gt;0,A1:A10))quot;Kris Andersenquot; wrote:

gt; I'm trying to calculate the average of ONLY the positive numbers from a
gt; column of both positive and negative numbers. I'm sure there's an easy way
gt; to do it, but everything I've tried hasn't worked. Any suggestions greatly
gt; appreciated!
gt;
gt; Kris

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Dialog box with worksheet information
此分類下一篇： Light grey grid-lines
上一篇： how do I write a formula to copy text from one cell to another?
下一篇： Setiiing up file name amp; path as a default setting on all sheets/ta

歷史上的今天

2007: In Excel, how do I find one word in a set of text in a cell?
2007: Does anyone have a good Status Report template for excel?
2007: Can I automatically sort worksheets in excel?
2007: Create macro
2007: #N/A
2007: # in cell
2007: Automatically apply a fill when entering text
2007: Parse csv files
2007: Autofilter doesn't work
2007: spread sheet
2007: Problem with data import from Access
2007: conditional formating colours to stay when numbers are deleted?
2007: Trying to access different files depening on a variable
2007: Please help!
2007: Help for sumif / sumproduct
2007: Operations (add, multiply) on all values ($00.00) in a column?
2007: how to protect formulas in a cell
2007: macros
2007: convert last, first names to intials
2007: Too many pages to print off
2007: Excel cannot open while web browser opened
2007: Is it possible to use a cell adress that is typed in a cell?
2007: =bahttext(A1) please tell me about language in english how can i
2007: Excel help
2007: Worksheet button to send as attachment
2007: .0 is creating #VALUE! Error
2007: Alphabet Worksheet
2007: Removing unwanted characters
2007: Little problem with this code...
2007: Tiered Calculation
2007: Overwriting Duplicates in certain cases
2007: Create folders in Window Explorer from tab or csv files export
2007: Excel 2003 worksheet graphics
2007: reference a cell on another sheet
2007: roundown
2007: how to delete or remove checkbox form control in Excel?
2007: =LOOKUP (show a blank if not available)
2007: Importing .pdf file into Excel
2007: activate macro only in sheet2
2007: Sum Duplicates
2007: Simple link to stored web page
2007: IF not numbers delete
2007: Pivot Tables
2007: Renaming Worksheet without using mouse??
2007: Big delay to recalculate formulas
2007: How do I change numbered columns to alphabet columns?
2007: Replacing characters in numeric text strings and SUMming
2007: removing gridlines in Excel spreadsheet
2007: Compare Sheet Cell to Sheet Column
2007: Creating lookup formulas for material cost spreadsheet
2007: wrap
2007: Custom Formula in Pivot Table Row
2007: Prevent cell data from converting to euros
2007: how 2 spreadsheets in diff locations with auto update
2007: Pivot table Data area show/hide behavior
2007: I have lost the in cell drop down in validation
2007: sumproduct formula
2007: If cell has one value, go to adjacent cell and count
2007: Concatenate Loop
2007: Sum a range based on a criterion
2007: How do I find the position of the lowest value in a row?
2007: SUMIF function using Criteria on different worksheet
2007: Outlook Calender to Excel Spreadsheet
2007: Merge Two Cells
2007: Two dimensional lookup problem
2007: Solver and Addin
2007: if.... Anyway around this?
2007: Database Query
2007: Excel 2000 using Web Query is slow on Excel 97
2007: Worksheet Protection
2007: How can I create a link between cells in two separate Excel sheet
2007: compare 2 columns
2007: To show quot;0quot; instead of #N/A
2007: hi i would like to know what this means }
2007: grouping in pivot tables
2007: Copying text value based on long (comlex) calculation
2007: Rearranging the layout of data
2007: Which function to uss to sum categories in a list?
2007: How to use covar in random number generation?
2007: How do I create a commission chart based on dates worked?
2007: Protect cells
2007: IF AND OR Worksheet Functions
2007: (c) automatically turning into copyright
2007: Fix for open/save files problem
2007: Cell Limitation
2007: SUMIF across worksheets
2007: How do you protect hidden linked worksheets with in an Excel workb
2007: How can I make an automatic calculation in changing sheet?
2007: Please help, I'm stuck
2007: Looking for Excel function
2007: 2nd to MAX
2007: INSIDER
2007: Excel 2003 -vs
2007: MS Query takes along time to open
2007: charts
2007: average 2 cells (Mileage Divide by Gallons in two cells
2007: highlighter
2007: How do I automate credit control
2007: Actual graphs
2007: Excel Formula?--gt; if A1=11am, then D5=A1; if A1=12pm, then D10=A1

留言列表

站方公告

活動快報

【船井...

newdirect

船井生醫推出專門針對高度用眼族、輕熟齡者的葉黃素... 看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)