Skip to Content

Replacing “Sumifs” for adding a value in given range

If the requirement is:- Adding the values in column B by checking the range in column A.

For Example, if the given range is from 100-200, then the values in cell B1,B2,B5,B6 should be added.

In dashboards, we are unable to use Sumifs so there is an alternative way for similar requirements.


What we can do here is, we can write a formula for a range lets say 100-200, so we will add the values which are greater than equal to 100 and from that we can subtract the values which are greater than equal to 200, so we will get the value which is falling between the range 100-200.

the formula is:- SUMIF(A1:B10,”>=100″,B1:B10)-SUMIF(A1:B10,”>=200″,B1:B10),

similarly SUMIF(A1:B10,”>=200″,B1:B10)-SUMIF(A1:B10,”>=300″,B1:B10) &


Below is the excel example for better understanding.


Hope this can help !


Yash Patel.

You must be Logged on to comment or reply to a post.