Jul 09 2019 04:53 AM
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.
Jul 09 2019 05:26 AM
=IF(($D10<>"")*(K10<>""),SUM(N10:Y10),"")
Jul 09 2019 05:28 AM
@Sergei Baklan Thank you! that works!