Sumifs with or, question

[jwillits]

So I have a sumifs formula I need to make and here is what I have.

=SUM(SUMIFS(D:D,H:H,"Jul 2018",E:E,{"*AMZN MKTP*","*AMAZON MKTPLACE*"}))

It doesn't seem to be working but what I am trying to say is,

Sum column D if Column H has Jul 2018 and Column E has AMZN MKTP or AMAZON MKTPLACE.

What am I doing wrong or what would the correct formula be?

 

[lrobbo314]

How about
=SUMPRODUCT(--(((ISNUMBER(SEARCH("AMZN MKTP",E:E)))+(ISNUMBER(SEARCH("AMAZON MKTPLACE",E:E))))*(H:H="Jul 2018"))*D:D)

 

[jwillits]

How about
=SUMPRODUCT(--(((ISNUMBER(SEARCH("AMZN MKTP",E:E)))+(ISNUMBER(SEARCH("AMAZON MKTPLACE",E:E))))*(H:H="Jul 2018"))*D:D)

Hmm, that doesnt seem to work either as it brings back a #VALUE !

 

[lrobbo314]

It's working on my test workbook. Can you post some sample data?

 

[RoryA]

The original formula is correct assuming column H actually contains text, and not dates formatted to display as just month and year.

 

[jwillits]

The original formula is correct assuming column H actually contains text, and not dates formatted to display as just month and year.

Yep, you are right, it was correct, looks like I shifted a column and it was trying to look at the wrong cell, thanks guys!