Forum Discussion
Properly COUNTBLANK and SUM function triggered error
Hi everyone, I'm having trouble with a formula in my spreadsheet that's giving me a "too many arguments" error. Specifically, the formula is: =IF(COUNTBLANK(F15,H15:K15)=5,"",SUM(F15,H15:K15...
Who told you that COUNTBLANK() could take more than ONE range reference?
=IF((COUNTBLANK(H15:K15)+COUNTBLANK(F15))=5,"",SUM(F15,H15:K15))Or the more complicated approach:
=SUM(F15,H15:K15)