Excel Sums with Multiple Criteria
May 20, 2008 9:18 AM Subscribe
Help me recreate these charts in Excel
posted by Frank Grimes to computers & internet (8 answers total)
I am trying to recreate these charts
in Excel. I have all of the data, but I want to manipulate it and create similar charts.
I cannot come up with the appropriate SUMIF or DSUM formulas that allow me to do this. Basically, I need a formula that says:
1) Pick a type of ship
2) Was the ship in service in the year in question?
3) Sum the gross tonnage of all ships that meet these criteria.
The hang up is the requirement of absolute references in the SUMIF and DSUM formulas (i.e. "Year=1990). I need a formula that I can drag across multiple years.