im on learning excel here. so i trying to sum a total unit based on region west and item is pencil. i try several things and it doesn't show any value, just blank. i try

=IF(AND(B:B="West";D:D="Pencil");SUMIF(D:D;"Pencil";E:E);"")

but it won't work.. please help.. :)

CodePudding user response：

You could change your formula to:

=SUMIFS(E:E;D:D;"Pencil";B:B;"West")