Rank and Sumifs

Hi and welcome to the forum

To arrive at the answers you have in your workbook, use this, copied down...
=SUMIF($F$2:$F$58,$J2,$H$2:$H$58)

However, I notice that those totals dont include the data you have below row 58 (81:111)?

to include thise as well, change that formula to...
=SUMIF($F:$F,$J2,$H:$H)

If you want to bring in additional criteria/restrictions such as "Work Center = QD-Line and Material = 7210743-16" between certain dates, you need to change the formula to a sumifS(). So it then becomes...

=SUMIFS($H$2:$H$58,$F$2:$F$58,$J2,$D$2:$D$58,"QD-Line",$E$2:$E$58,"7210743-16") = 828

To rank these values, we could create another similar table and use the rank() or large() functions to order them

Thank you both for your responses.

I found the following information online, and I was able to modify it for what I need. Thanks again!

http://www.mrexcel.com/forum/excel-q...ring-text.html