SUMIF and Wildcards

[Rainbowhawk]

Hi All

Currently got a sumif formula that works

=SUM(IF(Sheet3!$A$2:$A$1059=D15,IF(Sheet3!$D$2:$D$1059=D16,IF(Sheet3!$E$2:$E$1059=D17,IF(Sheet3!$F$2:$F$1059=D18,IF(Sheet3!$H$2:$H$1059=D19,Sheet3!$L$2:$L$1059,0),0)))))

Where D15,D16 etc are drop downs that allow me to filter the result, however I now need to include wildcards so I can disregard parts of the filter as required.

I have tried puting * in the drop down cells but get no result.

All thoughts and help appricated

Hawk

 

[MI man]

It would be better and more clear if you attach that spreadsheet here...

 

[NBVC]

Perhaps:

 =SUM(IF(IF(D15="*",Sheet3!$A$2:$A$1059<>"",Sheet3!$A$2:$A$1059=D15),IF(IF(D16="*",Sheet3!$D$2:$D$1059<>"",Sheet3!$D$2:$D$1059=D16),IF(IF(D17="*",Sheet3!$E$2:$E$1059<>"",Sheet3!$E$2:$E$1059=D17),IF(IF(D18="*",Sheet3!$F$2:$F$1059<>"",Sheet3!$F$2:$F$1059=D18),IF(IF(D19="*",Sheet3!$H$2:$H$1059<>"",Sheet3!$H$2:$H$1059=D19),Sheet3!$L$2:$L$1059))))))