Transferring SUMIFS to Google Sheets

Question:

( by Kayleigh Hudson )

In Excel I'm using the following formula:

 

=(SUMIFS($E:$E,$D:$D,{ʺHouseʺ,ʺEKʺ,ʺDEʺ,ʺESʺ,ʺDEKʺ,ʺDESʺ,ʺEKSʺ},$C:$C,ʺDʺ))-(SUMIFS($E:$E,$D:$D,{ʺHouseʺ,ʺDEʺ,ʺDKʺ,ʺDSʺ,ʺDEKʺ,ʺDESʺ,ʺDKSʺ},$C:$C,ʺEʺ))

 

Any ideas how to make this Google Sheets friendly? I've tried playing with FILTER some but then get the mismatched range error.

Solution:

Have a look at the following screenshot of my Spreadsheet:

I have the following formula in Cell G3:

=sum(iferror(filter(E:E;match(D:D;{"House","EK","DE","ES","DEK","DES","EKS"},0);C:C="D"))) + sum(iferror(filter(E:E;match(D:D;{"House","DE","DK","DS","DEK","DES","DKS"},0);C:C="E")))

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:

http://igoogledrive.blogspot.com/p/paid-projects.html

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan.

iGoogleDrive