| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging a row & dividing by only the qty. of cells with a value
I have a row of five cells - not all cells will be filled in. I need a
formula that will count only the cells that have a value and give me an average of that number then multiply that average with another cell. Ex: Cells A1, A3 have values. The formula should add A1:A5 but only divide by 2 (number of cells with value). If the total of A1 and A3 is divided by 5, my average will be diluted. Thanks, Carelle |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging a row & dividing by only the qty. of cells with a value
Have you tried this?:
=AVERAGE(A1:A5) The AVERAGE function disregards blanks and text..... Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Carelle" wrote in message ... I have a row of five cells - not all cells will be filled in. I need a formula that will count only the cells that have a value and give me an average of that number then multiply that average with another cell. Ex: Cells A1, A3 have values. The formula should add A1:A5 but only divide by 2 (number of cells with value). If the total of A1 and A3 is divided by 5, my average will be diluted. Thanks, Carelle |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging a row & dividing by only the qty. of cells with a va
Yes - thanks. I had a typo and was getting an error.
"Ron Coderre" wrote: Have you tried this?: =AVERAGE(A1:A5) The AVERAGE function disregards blanks and text..... Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Carelle" wrote in message ... I have a row of five cells - not all cells will be filled in. I need a formula that will count only the cells that have a value and give me an average of that number then multiply that average with another cell. Ex: Cells A1, A3 have values. The formula should add A1:A5 but only divide by 2 (number of cells with value). If the total of A1 and A3 is divided by 5, my average will be diluted. Thanks, Carelle |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging a row & dividing by only the qty. of cells with a va
I'm glad I could help.....thanks for the feedback.
-------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Carelle" wrote in message ... Yes - thanks. I had a typo and was getting an error. "Ron Coderre" wrote: Have you tried this?: =AVERAGE(A1:A5) The AVERAGE function disregards blanks and text..... Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Carelle" wrote in message ... I have a row of five cells - not all cells will be filled in. I need a formula that will count only the cells that have a value and give me an average of that number then multiply that average with another cell. Ex: Cells A1, A3 have values. The formula should add A1:A5 but only divide by 2 (number of cells with value). If the total of A1 and A3 is divided by 5, my average will be diluted. Thanks, Carelle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help w/ adding cells and dividing SUM by number of cells | Excel Worksheet Functions | |||
| Dividing cells by 1000 | Excel Discussion (Misc queries) | |||
| Dividing linked cells | Excel Worksheet Functions | |||
| Dividing Cells & Averages | Excel Discussion (Misc queries) | |||
| Dividing up cells | Excel Discussion (Misc queries) | |||
Linear Mode
