Thursday, January 10, 2019

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

No comments:

Post a Comment