Might be a dumb question, but here goes:

I'm trying to sum the product of the values in Column E and F (units and price) but only if two conditions exist...
  • If Cell B is Empty (signaling the order is open)
  • Cell C is the name of the product

Anyway here's a few codes that I've tried:
=SUMPRODUCT(--(B:B=""),--(C:C="AAPL"),F:F*E:E)
It just gives me the #VALUE! ...If I remove the *EE then it gives me just the sum...So Help!