SUMIFS on Excel

Looking to SUM a columns data if two other columns meet a certain criteria. 


Column A  = Norwich 


Colum B  = Used


SUM Column C

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Tom,

    Thanks for the post! 

    We support a SUMIF function that you can use in your formulas. For example, a formula like this will accomplish what you've outlined in your post: 

    SUMIF( AND( @A:A  = "Norwich" , @B:B = "Used" ) , @C:C ) 

    More information about this function can be found here

    I hope this helps! 


Please sign in to leave a comment.