Home

conditional formula if two cells are blank

%3CLINGO-SUB%20id%3D%22lingo-sub-744661%22%20slang%3D%22en-US%22%3Econditional%20formula%20if%20two%20cells%20are%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744661%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20sum%20a%20row%20as%20long%20as%20two%20cells%20are%20not%20blank%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(NOT(ISBLANK(AND(%24D10%3D%22%22%2CK10%3D%22%22)))%2CSUM(N10%3AY10)%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20does%20not%20work%20obviously%2C%20any%20help%20would%20be%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-744661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744712%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formula%20if%20two%20cells%20are%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373314%22%20target%3D%22_blank%22%3E%40juliesalala%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DIF((%24D10%26lt%3B%26gt%3B%22%22)*(K10%26lt%3B%26gt%3B%22%22)%2CSUM(N10%3AY10)%2C%22%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744717%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formula%20if%20two%20cells%20are%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744717%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you!%20that%20works!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745004%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formula%20if%20two%20cells%20are%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373314%22%20target%3D%22_blank%22%3E%40juliesalala%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
juliesalala
New 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
Highlighted

@juliesalala 

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

@Sergei Baklan Thank you! that works!

Highlighted

@juliesalala , you are welcome

Related Conversations
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies