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

@juliesalala 

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

@Sergei Baklan Thank you! that works!

@juliesalala , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies