Sumifs formula criteria (add or remove)

[Grimm127]

The sumif formula has a sum range, criteria range1, criteria1 those are required fileds
you can insert more criterita ( or 3, etc)

i am wondering if it is possible that based on a combo selection if a sumif formula can have 2 criterials for on instance and based on a selection only have 1 criteria.

So
if i select 2, then sumifs(sum range, criteria range1, criteria1, criteria range2, criteria2)
if i select 1, then sumifs(sum range, criteria range1, criteria1)

is that posible???????

 

[Aladin Akyurek]

Try something like:

SUMIFS(SumRange,CriteriaRange1,criteria1,CriteriaRange2,IF(selection=2,criteria2,"?*"))

 

[Grimm127]

Thank you for your reply:
On the surface its would seem to work but I think part of the issue is the criteria I am using is index based because of the selections need to sum in variable columns.

=SUMIFS(INDEX('2018A'!U:AF,0,$BG$8),INDEX('2018A'!A:H,0,$BG$11),$BF$11,INDEX('2018A'!A:H,0,$BG$12),IF(BG12=8,$BF$12,"?*"),'2018A'!J:J,$C$7)/1000

Could it be the text its returning that can be causing the #Value error?
What do you suggest?

 

[Aladin Akyurek]

How are supposed to know whether BG8, BG11, BF11, BG12, BF12, and C7 are of appropriate kind?

Care to formulate what you need in words?

 

[Grimm127]

BG8, BG11, BF11, BG12, BF12, and C7 are appropriate. Its based on a sumifs so is looks at those cells in the indexed columns.

Care to formulate what you need in words?[/QUOTE]

 

[Aladin Akyurek]

Is it still possible to get a problem description in words?