SUMIF

%3CLINGO-SUB%20id%3D%22lingo-sub-2872258%22%20slang%3D%22en-US%22%3ESUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2872258%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20get%20SUMIF%20to%20identify%20blank%20cells%20and%20than%20to%20add%20the%20monies%20from%20associated%20cells%20from%20another%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2872258%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2872497%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2872497%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1192582%22%20target%3D%22_blank%22%3E%40TRH33%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20kind%20of%20logic%20is%20that%3F%20you%20want%20to%20add%20all%20values%20that%20the%20criteria%20column%20is%20blank%20and%20apply%20it%20to%20associated%20cells%20in%20another%20column%3F%20can%20you%20share%20the%20data%20set%20to%20this%20range%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2872526%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2872526%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1192582%22%20target%3D%22_blank%22%3E%40TRH33%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DSUMIF%20(RangeToApplyCriteria%2C%20YourCriteria%2C%20sum_range)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EConsidering%20the%20B2%3AB20%20the%20range%20where%20you%20may%20have%20%22blank%20cells%22%20and%26nbsp%3BC2%3AC20%20the%20range%20containing%20the%20values%20you%20want%20to%20sum%2C%20use%20the%20following%20formula%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSUMIF(B2%3AB20%2C%22%22%2CC2%3AC20)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EFind%20attachment%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to get SUMIF to identify blank cells and than to add the monies from associated cells from another column.

2 Replies

@TRH33 

 

what kind of logic is that? you want to add all values that the criteria column is blank and apply it to associated cells in another column? can you share the data set to this range?

@TRH33 

=SUMIF (RangeToApplyCriteria, YourCriteria, sum_range)

Considering the B2:B20 the range where you may have "blank cells" and C2:C20 the range containing the values you want to sum, use the following formula

=SUMIF(B2:B20,"",C2:C20)

Find attachment