SOLVED

Formula assistance

Copper Contributor

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", Column F, row 7 is not working.  Can someone help me understand why the formula is not working and what can I do to resolve it?

 

It should be bringing in the amount of 

1,079,316-

 

You will also notice that on the tab called SAP Columns A&B are formulas.   

 

3 Replies

@elo0707 

See attached file.

best response confirmed by elo0707 (Copper Contributor)
Solution

@elo0707 

  1. 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))
  2. The value n work!D7 should be 499998, not 49998.
  3. The criteria ranges should be 'SAP '!A:A and 'SAP '!B:B instead of 'SAP '!B:B and 'SAP '!C:C.

HansVogelaar_0-1701295626750.png

Thank you for your assistance.
1 best response

Accepted Solutions
best response confirmed by elo0707 (Copper Contributor)
Solution

@elo0707 

  1. 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))
  2. The value n work!D7 should be 499998, not 49998.
  3. The criteria ranges should be 'SAP '!A:A and 'SAP '!B:B instead of 'SAP '!B:B and 'SAP '!C:C.

HansVogelaar_0-1701295626750.png

View solution in original post