nested function to add columns

D

donl

hello! is there a function that can check 3 columns, and based on the 3
columns, perform a calculation. here is what i am trying to do:

colA colB colC
Y N Y
Y Y Y
N N N

if all 3 columns are Y, then I want to add them together
(ColA+ColB+ColC)

Thanks!
 
D

donl

this is what i have so far:


=if(A1='Y',if(B1='Y',if(C1='Y',D1+E1+F1,0),0),0)


so if they are all Y's then i add cells e,f,g. but not working...
 
B

BenjieLop

donl said:
hello! is there a function that can check 3 columns, and based on the
columns, perform a calculation. here is what i am trying to do:

colA colB colC
Y N Y
Y Y Y
N N N

if all 3 columns are Y, then I want to add them togethe
(ColA+ColB+ColC)

Thanks!
Click to expand...

=IF(AND(A1=\"Y\",B1=\"Y\",C1=\"Y\"),SUM(D1:F1),\"\"

and copy down as required.

Hope this helps.

Regards
 
B

bj

If this is from your equation you need to chage the hyphens to quote marks
around the Ys.
 
Top