| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
@average function
I need help with a "simple" formula in a basic spreadsheet. I have the
months of the year in one column, and a dollar amount in the next column. Question: If I fill in a number in Jan, Feb, Mar, & April, and fill in zero's for the rest of the months, what would the formula be to figure the average of all months that have a number greater than zero? Thanks for your help. Dave |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
@average function
A2:A13 contain month
B2:B13 contain dollar amount =AVERAGE(IF(A2:A13<0,B2:B13)) ctrl+shift+enter, not just enter "Chazbri" wrote: I need help with a "simple" formula in a basic spreadsheet. I have the months of the year in one column, and a dollar amount in the next column. Question: If I fill in a number in Jan, Feb, Mar, & April, and fill in zero's for the rest of the months, what would the formula be to figure the average of all months that have a number greater than zero? Thanks for your help. Dave |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
@average function
"Chazbri" wrote...
I need help with a "simple" formula in a basic spreadsheet. I have the months of the year in one column, and a dollar amount in the next column. Question: If I fill in a number in Jan, Feb, Mar, & April, and fill in zero's for the rest of the months, what would the formula be to figure the average of all months that have a number greater than zero? .... Another alternative, =SUMIF(range,"0")/COUNTIF(range,"0") or for those using Excel 2007, =AVERAGEIF(range,"0") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGE function | Excel Worksheet Functions | |||
| function for average without zero | Excel Worksheet Functions | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Hybrid Mode
