SOLVED

Need help on IF/THEN formula

Copper Contributor

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
P               20,000
P               20,000
R               20,000
R               20,000
P               40,000
P Total 
R Total 

 

Thanks in advance for the help.

2 Replies
best response confirmed by MrM312 (Copper Contributor)
Solution
=SUMIF() or SUMIFS() i prefer the format of SUMIFS even if I only have 1 condition:
=SUMIFS( [Amount], [Code], "R")
I'll give it a try. Thanks!
1 best response

Accepted Solutions
best response confirmed by MrM312 (Copper Contributor)
Solution
=SUMIF() or SUMIFS() i prefer the format of SUMIFS even if I only have 1 condition:
=SUMIFS( [Amount], [Code], "R")

View solution in original post