Below is a sample of what I need. I will need to do this for over 20 accounts each with many Companies.
I am trying to update an Excel Standard Report already being used and they don't want Pivot Tables.
I know I can use SumIf or SumIfs functions or Dsum.
Just wondering is there a other formulas I might have missed to get this done.
Revenue Account xxx
Company A USP 100
Company B US 200
Company C For 300
Company D For 400
Company E For 500
Company F For 600
Company G For 700
Total Rev Account xxx 2800
USP US Total US FOR Grand total
Revenue xxx 100 200 300 2500 2800
2 posts • Page 1 of 1