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

Hi Granger

One way
=SUMPRODUCT(--(range1=$B$8),--(range2=$H$6))

Substitute your cell range where the data is held for range1 and range2
Regards

Roger Govier


Granger wrote:
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

=SUMPRODUCT(--(M2:M200=B8),--(N2:N200=H6),O2:O200)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Granger" wrote in message
oups.com...
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

Excellent!!! Thanks Roger and Bob!!!!