Tuesday, August 13, 2013

Transferring SUMIFS to Google Sheets


( by Kayleigh Hudson )

In Excel I'm using the following formula:
Any ideas how to make this Google Sheets friendly? I've tried playing with FILTER some but then get the mismatched range error.


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:
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 


No comments:

Post a Comment