Forum Discussion

rc14354's avatar
rc14354
Copper Contributor
Mar 29, 2019
Solved

SUM.IF

Hi team, I'm using sum.if formula on two different tables. The criteria to sum up amounts is the list of numbers here below. 5806524220010000003340946 5806524220010000016288417 58065242200100000...
excel
Formulas and Functions
lori_m's avatar
lori_m
Iron Contributor
Mar 29, 2019
Detlef_Lewin Hey just noticed this link! Indeed for numeric text you can use:

=SUMIF(range, CHAR(173)&criteria, [sum_range])

Glad others have picked up on this and it's been put to good use :)
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Mar 29, 2019

    lori_m 

    Ah! The discoverer herself.

    Solving an eleven year old problem which annoyed almost every Excel user is always worth mentioning.

     

Resources