G
Granger
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
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