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.
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.