sumifs query

Hi, I used the Sumifs function on multiple criteria but I am not getting the correct result. Would appreciate someone looking at my formula to see where I am going wrong. I have attached a small spreadsheet example....thanks

=SUMPRODUCT(E2:E15,(--(B2:B15="level1")+--(B2:B15="level3")+--(B2:B15="level5")),(--(C2:C15="permanent")+--(C2:C15="casual")),(--(D2:D15="store2")+--(D2:D15="store3")))

Use the formula

Formula:

Please Login or Register  to view this content.

Hi, thank you dan4ish and Jose Augusto for your Sumproduct formulas, they work great and I will use them. The formula I initially showed does tend to work on and off, it is not a consistent formula that gives consistent results......can you please tell me should I avoid the sum(sumifs scenario?