nested function to add columns

[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!

 

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

 

[BenjieLop]

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!

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

and copy down as required.

Hope this helps.

Regards

 

[donl]

it works! Thanks!!

 

[Guest]

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

 

[BenjieLop]

Thank you for the feedback ... glad that I can help.

Regards.