Sreamline Sum If formula

[howard]

I have descriptions in Col B and values in Col C


I have the following SumIF formula to extract the various values based on the descriptions that I which to extract their values

The formula gives me the correct result, but slow down my Laptop

I would like to know if this formula can be simplified

Your assistance in this regard is most appreciated

 =SUM(SUMIFS(C:C,B:B,({"*lab Ret*","*lab Trade*","*S/Let Ret*","*s/let Trade*","*access?SVC*","*breakdown?*svc*","*oils Ret*","*Oils War*","*Con?*ret*","*Sale?*F&I*","*Sale*RO*RET*Br1*PARTS*","*Sale*RO*FLT*Br1*PARTS*","*Sale*RO*RET*BZ1*PARTS*","*Sale*RO*FLT*BZ1*PARTS*","*Sale*RO*RET*Non*PARTS*","*Sale*RO*FLT*Non*PARTS*","*Sale*RO*RET*access*PARTS*","*Sale*RO*FLT*access*","*DISC*RO*Ret*Br1*PARTs*","*DISC*RO*FLT*Br1*PARTs*","*DISC*RO*Ret*BZ1*PARTs*","*DISC*RO*FLT*BZ1*PARTs*","*DISC*RO*Ret*Non-Fr*PARTs*","*DISC*RO*FLT*Non-fr*PARTs*","*Sale*RO*RET*Oils*","*Sale*RO*FLT*Oils*","*Disc*RO*RET*Oils*","*Disc*RO*FLT*Oils*"})))

 

[arthurbr]

Why do you need the first SUM function?
Also try using shorter ranges.

 

[Aladin Akyurek]

I have descriptions in Col B and values in Col C


I have the following SumIF formula to extract the various values based on the descriptions that I which to extract their values

The formula gives me the correct result, but slow down my Laptop

I would like to know if this formula can be simplified

Your assistance in this regard is most appreciated
Try...

=SUMPRODUCT(SUMIFS(C:C,B:B,CondList))

where CondList refers to a range which houses all of your conditions as follows...

*lab Ret*
*lab Trade*
*S/Let Ret*
*s/let Trade*
*access?SVC*
*breakdown?*svc*

etc.
etc.

 

[howard]

Thanks Aladin. Formula work perfectly

 

[howard]

Thanks for your input Arthur

I thought that one needs to use =sum(Sumifs.... when adding a range of criteria

I will shorten the range

 

[Aladin Akyurek]

Thanks Aladin. Formula work perfectly

You are welcome.

 

[arthurbr]

Thanks for your input Arthur

I thought that one needs to use =sum(Sumifs.... when adding a range of criteria

I will shorten the range

Most welcome