Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AVERAGEIF Function out there?
Is anybody out there aware of an "AVERAGEIF" function ?.
I'm new to programming and have failed miserably trying to write it. Any help would be great. |
#2
|
|||
|
|||
No need to write a function, you can use a combination of average and if
as an example =AVERAGE(IF(Range=criteria,Range)) entered with ctrl + shift & enter Regards, Peo Sjoblom "davidad" wrote: Is anybody out there aware of an "AVERAGEIF" function ?. I'm new to programming and have failed miserably trying to write it. Any help would be great. |
#3
|
|||
|
|||
davidad wrote:
Is anybody out there aware of an "AVERAGEIF" function ?. I'm new to programming and have failed miserably trying to write it. Any help would be great. -------------------------- Peo gave you the "right" solution. Here's the more intuitive one: [ ] = SumIf(A1:A5,"0")/CountIf(A1:A5,"0") Obviously you'll need to substitute your own arguments into it, but it should give you the idea. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging function | Excel Discussion (Misc queries) | |||
Accessing a Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |