Forum Discussion
Need help with creating a formula
Still learning more complex formulas with excel, so some help would be appreciated with some steps to make this happen. I'm trying to process a large group of data to come up with a few different...
=SUMIF($A$2:$A$23,$A2,$C$2:$C$23)>500You can apply this rule for conditional formatting.
=$A$2:$D$23This is the range the conditional format applies to.
=IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$23,A2),SUMIF($A$2:A2,A2,$C$2:C2),"")This formula returns the results in column D.