Excel 2016 Best Formula to Sum Data

User avatar
Posts: 26
Joined: 15 Feb 2010, 18:04

Excel 2016 Best Formula to Sum Data

Post by Tom54 »

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

Summary REPORT

USP US Total US FOR Grand total
Revenue xxx 100 200 300 2500 2800


User avatar
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel 2016 Best Formula to Sum Data

Post by HansV »

SUMIF(S) is probably best. If you'd like us to look at it in more detail, please attach a sample workbook.