Yes, you are right

My mistake

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"David Biddulph" escreveu:

Yes, but did you try your formula with ...*(a8:b13)) ?

Did that give the product of columns A and B? I think not.
--
David Biddulph

"Marcelo" wrote in message
...
Yes David, I repost the correct with the =51

thanks
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"David Biddulph" escreveu:

Marcelo may have intended to say not =sumproduct(--(c8:c13)*(a8:b13))
but either =sumproduct((c8:c13=51)*(a8:a13)*(b8:b13)) or
=sumproduct(--(c8:c13=51),a8:a13,b8:b13) ?

[You don't need the double unary minus if you've already got an
arithmetic
operator such as the * for multiply.]
--
David Biddulph

"Marcelo" wrote in message
...
Try
Assuming your data is on a8:c13

=sumproduct(--(c8:c13)*(a8:b13))

"Angie" escreveu:

I hope someone can help me. How can I sum the products of columns A
and
B,
but only if the value in column C meets a certain criteria (like =
51)?