G
Guest
Hi there:
Am using a sumproduct formula that looks like this:
=sumproduct(A1:A10="Y")*(B1:B10>5),(C1:C10)
Which did not work
So I tried
=sumproduct(A1:A10="Y")*(B1:B10">5"),(C1:C10)
Which did not work either.
Does some product not work with numeric conditions like >5? Is it only for
text conditions like ="Y"?
Thanks!
Am using a sumproduct formula that looks like this:
=sumproduct(A1:A10="Y")*(B1:B10>5),(C1:C10)
Which did not work
So I tried
=sumproduct(A1:A10="Y")*(B1:B10">5"),(C1:C10)
Which did not work either.
Does some product not work with numeric conditions like >5? Is it only for
text conditions like ="Y"?
Thanks!