Count data, compare and display answer

Question

Ok so I am not sure how the best way to go about this.&nbsp; I have a spreadsheet that I enter data in and I need it to look in Column G and decipher if there are duplicate combinations.&nbsp; If there are then I need it to display a dollar amount in column M.&nbsp; The data it has to decipher is:GNDXTV&nbsp;&nbsp;&nbsp;&nbsp;30KQLCGX&nbsp;&nbsp;&nbsp;&nbsp;30FUNPQO&nbsp;&nbsp;&nbsp;&nbsp;30GLDAUV&nbsp;&nbsp;&nbsp;&nbsp;30ECHGGI&nbsp;&nbsp;&nbsp;&nbsp;30TPOFLD&nbsp;&nbsp;&nbsp;&nbsp;30LRMDIC&nbsp;&nbsp;&nbsp;&nbsp;30LRMDIC&nbsp;&nbsp;&nbsp;&nbsp;40TPOFLD&nbsp;&nbsp;&nbsp;&nbsp;30HJPTZZ&nbsp;&nbsp;&nbsp;&nbsp;30RYRMOR&nbsp;&nbsp;&nbsp;&nbsp;30BFMGLS&nbsp;&nbsp;&nbsp;&nbsp;30&nbsp;CMUJJU&nbsp;&nbsp;&nbsp;&nbsp;30CMUJJU&nbsp;&nbsp;&nbsp;&nbsp;40UROUXV&nbsp;&nbsp;&nbsp;&nbsp;30&nbsp;For example when it notices that CMUJJU is there twice it would add 30+40 and then display $70 in column M.&nbsp; If it counts only 1 occurrence then it display $30 in column M.&nbsp; I am guessing that using COUNT and IF statements is going to be where I need to head but not sure.&nbsp; I am using 365.&nbsp; Any guidance would be appreciated.&nbsp;Thanks,&nbsp;&nbsp;

oliverscheurich · Answer

rickdean&nbsp;=IF(COUNTIF($G$3:$G$17,G3)&gt;1,SUMIF($G$3:$G$17,G3,$H$3:$H$17),H3)You can try this formula.

Forum Discussion

Count data, compare and display answer

1 Reply

Resources

GNDXTV	30
KQLCGX	30
FUNPQO	30
GLDAUV	30
ECHGGI	30
TPOFLD	30
LRMDIC	30
LRMDIC	40
TPOFLD	30
HJPTZZ	30
RYRMOR	30
BFMGLS	30
CMUJJU	30
CMUJJU	40
UROUXV	30