SUMIF Function – Summing Cells using a Condition

In a previous post I talked about how to SUM cells using Excel’s SUM function.  This is a great way to sum cells quickly, but did you also know

you can sum Excel cells based on ausing-sumif-in-excel criteria you specify?

  Looking at the image opposite, you could actually sum only the cells that contain a value greater than 20, or any other numerical value you like.  The formula is highlighted in the green circle, and values greater than 20 are shown in yellow.

Using the SUMIF Function

To get the answer of 66 as shown in the image in cell B10, you need to type the following

=SUMIF(B2:B9,">20",(B2:B9))

Let’s break it down into it’s three parts.

Part One –  =SUMIF(B2:B9)
Here we are telling excel we want to sum the range of cells selected (B2:B9) if they meet a criteria we later specify in part two.

Part Two –  ,”>20″,
This is where specify the criteria on which to select the cells to sum.  Here I have told excel to only sum cells that contain a value greater than 20.  The greater than symbol, > , could also be reversed using, < , to say less than.  If you only wanted to sum cells with a specific number then you do not need the quotation marks ” ” at the beginning and the end of this section.

Part Three –  (B2:B9))
Finally, the section specifies the range to be summed.  Generally this would be the same as the range specified in part one.  Note the second closing bracket at the end.  This is required because two opening brackets were used earlier on in the formula.

858 thoughts on “SUMIF Function – Summing Cells using a Condition

  1. Assistir Jogos Ao Vivo App

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. App Perfect Player Para Smart Tv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  3. hentaisea.com

    Wow, fantastic weblog format! How long have you been blogging for? you make running a blog look easy. The entire glance of your web site is great, let alone the content material!

  4. 192.168.1.1

    It’а†s really a cool and helpful piece of info. I am satisfied that you shared this useful info with us. Please stay us informed like this. Thank you for sharing.

Comments are closed.