Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
daverage worksheet function
I have the following data and want to calculate an average of the % for the
projects sold or not sold. Should I use daverage but how does the criteria need to specified if it has to be in a range? R1 ColA ColB ColC R2 Project 1 10% sold R3 Project 2 20% not sold R4 Project 3 20% not sold R5 Project 4 50% sold Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
daverage worksheet function
Average of percentages for 'sold'.
Please note that this is an array formula. You create array formulas in the same way that you create other formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula}" =AVERAGE(IF(C1:C100="sold",B1:B100)) If this post helps click Yes --------------- Jacob Skaria "Dave" wrote: I have the following data and want to calculate an average of the % for the projects sold or not sold. Should I use daverage but how does the criteria need to specified if it has to be in a range? R1 ColA ColB ColC R2 Project 1 10% sold R3 Project 2 20% not sold R4 Project 3 20% not sold R5 Project 4 50% sold Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAVERAGE, MIN, and MAX from another worksheet | Excel Worksheet Functions | |||
#DIV/0! error with DAVERAGE Function | Excel Worksheet Functions | |||
Daverage function with rows instead of colums. | Excel Worksheet Functions | |||
How to tackle Division by zero for DAVERAGE function | Excel Worksheet Functions | |||
DAverage Function help needed | Excel Worksheet Functions |