Average with More Than One Criteria

Hello Everyone,

Attached is sample spreadsheet, how would you average the transaction from January Week 2 to February Week 3, meaning transaction from January Week 2,January Week 3,January Week 4, January Week 5, February Week 1, February Week 2, February Week 3?

Thank you very much!
Hudas

you could use an array formula, something like this

=AVERAGE(IF(A2:A16="January",IF(INT(RIGHT(B2:B16,1))>=2,C2:C16)),IF(A2:A16="February",IF(INT(RIGHT(B2:B16,1))<=3,C2:C16)))

confirmed with Ctrl+Shift+Enter

Hi DGagnon,

It worked perfectly, one last question, what part of the formula I will change if I am to average the data from January Week 1 to February Week 4?

Thank you!!
Hudas

you would change the number that i have bolded

=AVERAGE(IF(A2:A16="January",IF(INT(RIGHT(B2:B16,1))>=2,C2:C16)),IF(A2:A16="February",IF(INT(RIGHT(B 2:B16,1))<=3,C2:C16)))

also note, if you span more than 2 months, you will need to add an additional if statement

@Dennis7849 Thank you very much!! though I prefer the formula given by DGagnon because I'm gonna be using a dynamic range for this. Thanks anyway!!

Thank you both of you!!

Thank you both of you!! @DGagnon I can't give you +rep because it's giving me this "You must spread some Reputation around before giving it to DGagnon again."

no problem, im glad i could assist, I was probably the last person that you gave rep to, i dont think you can rep the same person 2 times in a row.

On another note, i woudl recomend that for this exercise, if possible using real dates (eg the first date of the week) in an additional row you could do any sum or average based off of that in a more simple way.