yogi_Pull Data From Another Tab Based On Combination Of Two Out Of Three DropDowns

Google Spreadsheet   Post  #2574

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-10-2019

question by: Kenny Buckles:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/EZ6OBGDrjPI;context-place=mydiscussions
AVERAGEIFS Formula with Data Validation Field Criteria

Is it possible to have an AVERAGEIFS formula where the criteria is pulled from a data validation field.  But have the formula ignore if one of the criteria is blank?

For example - I have Criteria A, Criteria B, Criteria C and in my formula I want to pull the average from a range if it's just Criteria A, or if it's Criteria A+B, or if it's Criteria B+C.  I'm basically trying to provide filtering using data validation for a chart.

Thanks.

-----------------------------------------------------------------------------------------------------------

I am not sure how AVERAGEIFs figures in this  -- however following is my proposed solution