Need help on IF/THEN formula

Question

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?CodeAmountR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20,000R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20,000P&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20,000P&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20,000R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20,000R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20,000P&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40,000P Total&nbsp;R Total&nbsp;&nbsp;Thanks in advance for the help.

mtarler · Accepted Answer

=SUMIF() or SUMIFS() i prefer the format of SUMIFS even if I only have 1 condition:=SUMIFS( [Amount], [Code], "R")

Forum Discussion

Need help on IF/THEN formula

2 Replies

Resources

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