Forum Discussion

MrM312's avatar
MrM312
Copper Contributor
Jun 17, 2022
Solved

Need help on IF/THEN formula

I searched but could not find an answer that I could get to work. Looking to sum all cells with same code. Is this possible? Code Amount R                20,000 R                20,000...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Jun 17, 2022
    =SUMIF() or SUMIFS() i prefer the format of SUMIFS even if I only have 1 condition:
    =SUMIFS( [Amount], [Code], "R")
mtarler's avatar
mtarler
Silver Contributor
Jun 17, 2022
=SUMIF() or SUMIFS() i prefer the format of SUMIFS even if I only have 1 condition:
=SUMIFS( [Amount], [Code], "R")
  • MrM312's avatar
    MrM312
    Copper Contributor
    Jun 17, 2022
    I'll give it a try. Thanks!

Resources