Forum Discussion
elo0707
Nov 29, 2023Copper Contributor
Formula assistance
Good Afternoon Excel Community. I am seeking your assistance in resolving an ongoing problem that I am experiencing and can't figure out how to resolve. My sumifs formula on Tab named "WORK", Col...
- Nov 29, 2023
- The formulas in 'SAP '!A13:A24 return " B75" (beginning with a space), not "B75". Either add a space at the beginning of work!D7, or change the formulas in 'SAP '!A13:A24 to =IF(ISERROR(FIND("*",C13)),A14,MID(C13,4,3))
- The value n work!D7 should be 499998, not 49998.
- The criteria ranges should be 'SAP '!A:A and 'SAP '!B:B instead of 'SAP '!B:B and 'SAP '!C:C.
OliverScheurich
Gold Contributor
See attached file.
elo0707
Dec 05, 2023Copper Contributor
Thank you for your assistance.