averageifs/or ?

[reevesk]

Forgive me as this is my first time posting on this site, or asking for help over text for that matter. I hope I am able to clearly explain what I’m needing.

I have a report on one tab with formulas pulling from numerous different tabs in the same sheet. The report/formulas split the data into current month, previous month, and year to date. We also want to add in a drop down at the first “year to date” cell (D3) to change it to “year to period.” I’ve got the drop down working (using data validation), but now I need to edit the formulas in these cells so that once the drop down in cell D3 changes to year to period, the formula only pulls year to period data.

Currently, my formula (that works correctly) in my YTD column looks like this:
=AVERAGEIFS('Tab 1'!$O:$O,'Tab 1'!$A:$A,YEAR($B$5), 'Tab 1'!$C:$C,$A$38)
What I think I need is a formula that says “If cell D3=Year-to-Date, use this formula(above), but if cell D3=Year-to-Period, use a slightly different formula (which I haven't put together yet...)

So something along the lines of =averageifs(or(

(it has to be averageifS because I have more than one criteria)


I really don’t know if this is going to make sense to anyone…. But any input is appreciated!

 

[Jonmo1]

Welcome to the board

Sounds more like an IF

=IF(D3="Year-to-Date",AVERAGEIFS('Tab 1'!$O:$O,'Tab 1'!$A:$A,YEAR($B$5), 'Tab 1'!$C:$C,$A$38),slightlydifferentformulagoeshere)

 

[reevesk]

Welcome to the board

Sounds more like an IF

=IF(D3="Year-to-Date",AVERAGEIFS('Tab 1'!$O:$O,'Tab 1'!$A:$A,YEAR($B$5), 'Tab 1'!$C:$C,$A$38),slightlydifferentformulagoeshere)

Yes!!! That absolutely helped me.


Now just to figure out my "slightly different formula" pulling year to period/month.


Thank you so much for your quick response!

 

[Jonmo1]

You're welcome.