formula help (excel 2002)

  • Thread starter Thread starter Mitchell Warden
  • Start date Start date
M

Mitchell Warden

I've been trying for a while now, but i havent been able to find a way to do
the following. Hopefully someone might be able to help?
I have data in 3 coloumns, the first column is just a YES or NO. The other
two contain numeric values.
I need to check the value in column A (for example), and if it is YES, then
multiply the corresponding values in B and C columns by each other, for
every row (that contains YES in column A), then add the result. I've been
able to use the SUMPRODUCT function to do nearly what I want, but it does
all the rows. I only am interested in ones with YES in column A. A
SUMPRODUCTIF function would be nice.
Thanks for any help.
 
=SUMPRODUCT((A1:A28="YES")*(B1:B28*C1:C28))
or
=SUMPRODUCT((A1:A28="YES")*(B1:B28)*(C1:C28))

Only difference is presentation in terms of brackets. Some find it easier to read with, some
without.
 
Correct typo for B1B10
=SUMPRODUCT((A1:A10="Yes")*(B1:B10)*(C1:C10))

Regards,
Tom Ogilvy
 
Back
Top