Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average Formula
Hi,
I need to calculate average of 3 months. However, if any particular month is defying the normal trend, that month should be ignored while calculating the average. For Eg: Jan Feb Mar Average 2 2 2 2 4 4 6 4 2 1 2 2 Is this possible? Regards, Vinaya. |
#2
|
|||
|
|||
If you can quantify what "defying the normal trend" means, then you
could use an array formula (entered with Ctrl-Shift-Enter) like =AVERAGE(IF(intrend(range),range)) where intrend(range) is an array formula that returns TRUE or FALSE for each cell in range, depending on whether that cell should be included in the average or not. Jerry Vinaya wrote: Hi, I need to calculate average of 3 months. However, if any particular month is defying the normal trend, that month should be ignored while calculating the average. For Eg: Jan Feb Mar Average 2 2 2 2 4 4 6 4 2 1 2 2 Is this possible? Regards, Vinaya. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Formula to average ignoring negatives? | Excel Discussion (Misc queries) |