So I've tried this formula and I'm only part way there for what I need. I want to sum the net amt. in the sequences below based on invoice #, but have the total appear on each sequence line. I want the sum of column F to appear in each cell in column C, but only if the data in Column A is the same.
This is what I used (close but not there):
This is what I used (close but not there):
=IF(COUNTIF($A$2:A2,A2)=1,SUMIF($A:$A,A2,$F:$F),"") This is what I get (not what I want): This is what I want, but I'm stumped on the formula. Any suggestions/help is appreciated: |