Forum Discussion

thecheesenone's avatar
thecheesenone
Copper Contributor
Oct 12, 2023

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))

 

 

I suspect the issue is with the extra comma between F15 and H15, I don't think it should be a problem, but because I use it properly within COUTBLANK and SUM function. I'm not sure how to fix it. Can anyone help me troubleshoot this formula?

Thanks in advance for your help!

excel
Formulas and Functions

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Oct 12, 2023

    thecheesenone 

    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)

     

Resources