conditional formula if two cells are blank

Copper Contributor

I want to sum a row as long as two cells are not blank:

 

=IF(NOT(ISBLANK(AND($D10="",K10=""))),SUM(N10:Y10),"")

 

This does not work obviously, any help would be greatly appreciated. 

3 Replies

@juliesalala 

=IF(($D10<>"")*(K10<>""),SUM(N10:Y10),"")

@Sergei Baklan Thank you! that works!

@juliesalala , you are welcome