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.

Capturee.JPG

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

SUMIF(A1:B10,”>=300″,B1:B10)-SUMIF(A1:B10,”>=400″,B1:B10)

Below is the excel example for better understanding.

group_sum.JPG

Hope this can help !

Thanks,

Yash Patel.

To report this post you need to login first.

1 Comment

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

Leave a Reply