CODEWITHSUNDEEP
excelexcel-formulavba
Luis
Luis

Reputation: 139

Using a array with sumifs

The purpose of this formula is to sum the values in K if values from column B are 20x, 200, 702, 201 and also if values in column E is only IS and also values in column L read dam. I am receiving a value of 0 and I know that the value is more than 0 I think it's my array that I am not using correctly. Below is my formula I'm currently using and a screenshot of the data.

=SUMIFS($K$2:$K$5000,$B$2:$B$5000,"*20X*","200","702","201"},$E$2:$E$5000,"IS",$L$2:$L$5000,"*dam*")

DATA

enter image description here

Upvotes: 2

Views: 885

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

There may be problems copying the formula from the Comments. This works:

=SUM(SUMIFS($K$2:$K$5000,$B$2:$B$5000,{"*20X*","200","702","201"},$E$2:$E$5000,"IS",$L$2:$L$5000,"*dam*"))

enter image description here

Upvotes: 1

Related Questions