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!
Last edited by wvpersephone13; 05-21-2012 at 01:13 PM. Reason: Solved
Put this in F10...
=SUMIF($C$3:$C$9,$E15,F$4:F$10)
...and copy it down and across to Q19.
Note; for your data configuration, it is necessary for the sum rows F$4:F$10 to be offset by one row from the criteria rows $C$3:$C$9.
Last edited by AlphaFrog; 05-21-2012 at 10:22 AM.
Thank you AlphaFrog. What do you mean by your Note statement? When I copied this over to my larger spreadsheet, it appears to be adding all of column F, instead of just the alternating lines I want to add.
I don't know how your Larger sheet is configured.
On your Sample sheet, every two cell pairs in C3:C10 are merged. Only the first cell in the merged pairs has the value. As a test, put this in two empty cells =C3 and =C4. Only C3 returns a value.
The rows in column F you want to Sum is one row below the matched row in column C. So if C3 is a match, then you want to sum from F4. That's why "it is necessary for the sum rows F$4:F$10 to be offset by one row from the criteria rows $C$3:$C$9."
If your Larger sheet is configured differently, you may need to change the formula.
Ah, I understand now. This works perfectly, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
More Information
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks