Averageifs with 5 criteria

[sharknuts5]

Good Afternoon,

I have an averageifs formula written that works with 5 criteria. The five criteria are selected from 5 different drop down lists. I cannot figure out how to only use 2 or 3 of the criteria as opposed to all 5. If i blank out the others i get a div/0. Any thoughts as to how i can do this without VBA?

Please Login or Register  to view this content.

Best,
Steve

[daffodil11]

Using OR logic is a little bit more complex, but still very doable spreadsheet side.

Please Login or Register  to view this content.

[sharknuts5]

awesome!! thank you so much!!

[daffodil11]

No problem, glad I could help out.