Sum Array based on Col + Row

[bubbafish]

What formula would let me sum an array (C5..I9) where Col (B5..B9) has a Yes or No and Row (C4..I4) that has various names in them and if the one of the names is “USE” it would be included. So I would want to sum a range based on what is in a corresponding column and row.
Thanks!

 

[T. Valko]

What formula would let me sum an array (C5..I9) where Col (B5..B9) has a Yes or No and Row (C4..I4) that has various names in them and if the one of the names is “USE” it would be included. So I would want to sum a range based on what is in a corresponding column and row.
Thanks!

Maybe something like this...

=SUMPRODUCT((B5:B9="yes")*(C4:I4="use")*C5:I9)

 

[WinteE]

=SUMPRODUCT((B5:B9="Yes")*(C4:I4="USE")*(C5:I9))

 

[bubbafish]

I tried that and it gave me "0" as an answer.

 

[Jonmo1]

Either:
None of the values in B5:B9 = yes (check spelling, look for extra spaces)
or
None of the values in C4:I4 = use (check spelling, look for extra spaces)
or
None of the values in C5:I9 are actually numbers
or
The corresponding values just happen to add up to 0

 

[bubbafish]

It's Monday.....short between the seat and keyboard... works like a charm.

 

[T. Valko]

It's Monday.....short between the seat and keyboard... works like a charm.

Good deal. Thanks for feeding back!