average multiple criteria

[billandrew]

Hello All

My question this afternoon, Is there an alternate way to average December January & February

The formula I am using is

={SUM(SUMIFS($B$5:$B$16,$A$5:$A$16,{"December","January","February"}))/SUM(COUNTIFS($A$5:$A$16,{"December","January","February"}))}

January	25
February	36
March	35
April	24
May	15
June	18
July	65
August	25
September	36
October	45
November	12
December	32

<tbody>
</tbody>

 

[Eric W]

If you make a list of the months, you can do this:

	A	B	C	D	E	F
4						Months
5	January	25		31	31	December
6	February	36			31	January
7	March	35				February
8	April	24
9	May	15
10	June	18
11	July	65
12	August	25
13	September	36
14	October	45
15	November	12
16	December	32
17

<tbody>
</tbody>

Sheet9​

Worksheet Formulas Cell Formula D5 =SUM(SUMIFS($B$5:$B$16,$A$5:$A$16,{"December","January","February"}))/SUM(COUNTIFS($A$5:$A$16,{"December","January","February"})) <tbody> </tbody>

<tbody>
</tbody>

Array Formulas Cell Formula E5 {=AVERAGE(IF(ISNUMBER(MATCH(A5:A16,F5:F7,0)),B5:B16))} E6 {=AVERAGE(IF(ISNUMBER(MATCH(A5:A16,{"December","January","February"},0)),B5:B16))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

You can make an external list, or internal to the formula.

 

[johnmpl]

Hi, to both of you!

Another options could be:

Book1
	A	B	C	D	E	F
5	January	25		31	31	December
6	February	36				January
7	March	35				February
8	April	24
9	May	15
10	June	18
11	July	65
12	August	25
13	September	36
14	October	45
15	November	12
16	December	32
Hoja1

Cell Formulas
Range	Formula
D5	=AVERAGE(SUMIF(A5:A16,{"December";"January";"February"},B5:B16))
E5	{=AVERAGE(IF(COUNTIF(F5:F7,A5:A16),B5:B16))}
Press CTRL+SHIFT+ENTER to enter array formulas.

Blessings!

 

[billandrew]

Both worked

Thank You Eric & John....