Hello,

I am trying to write a formula to do the following:

Sum the contents of a row for a specific "week" and a specific Category
"Machine 1"

So, if I enter a "5" for production week 5 in cell B8 and a "Mach 1"
for the machine I am looking at in cell H6, what formula in F8 will go
though the data sheet and return a sum of a specific column when it
meets those conditions?

I have tried nesting SUMIF's with no luck and I have tried leveraging
my VERY limited knowledge of arrays to no avail

Any suggestions would be greatly appreciated!!!!

-Bryan