Hello. I am creating a spreadsheet that will add up the monthly totals of specified materials. ie For all projects that use material "C110", I want monthly totals of how many pounds of that material were used. I have attached a sample spreadsheet to further explain what I am trying to do. It's probably a simple formula, I'm just not sure how to get the SUMIF function to work across multiple rows. In reality, this spreadsheet will be much longer. Thanks for the help!
Bookmarks