I have a 2007 spreadsheet that is looking to another worksheet Column F for
the month of March, Column K for salesperson Dawn, and Column D for a product
code, once all these conditions have been met it is totalling those sales
values in column E. The problem is Column D. I want it to find BRD, or, SPG,
or ADR. The formula I have below is only finding BRD, it's not recognizing
the other 2 product options?

=(SUMIFS(Goldmine!$E$2:$E$1000,Goldmine!$F$2:$F$10 00,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$ D$2:$D$1000,{"BRD","SPG","ADR"}))/1000