I want to sum e11 through n11 if d11 is "yes" I can't make it work...please help
N Nancy Aug 16, 2006 #1 I want to sum e11 through n11 if d11 is "yes" I can't make it work...please help
B Bob Phillips Aug 16, 2006 #2 =IF(D11="yes",SUM(E11:N11),"") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=IF(D11="yes",SUM(E11:N11),"") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
M Max Aug 16, 2006 #3 Nancy said: I want to sum e11 through n11 if d11 is "yes" Click to expand... Maybe: =IF(D11="yes",SUM(E11:N11),"") Presumes we want "nothing", ie:"" to show in the formula cell if D11 does not contain "yes" (not stated in the post)
Nancy said: I want to sum e11 through n11 if d11 is "yes" Click to expand... Maybe: =IF(D11="yes",SUM(E11:N11),"") Presumes we want "nothing", ie:"" to show in the formula cell if D11 does not contain "yes" (not stated in the post)
