SUMIFS only for certain criteria...

Try

=SUMIFS(E:E,I:I,$O$3,D:D,$O$4,C:C,$O$5,H:H,$O$6,K:K,$O$7,J:J,$O$8)

Make your selections DV lists and include "*" (without quotes) as a criteria in the lists (meaning ALL).

Thanks John - I'd tried adding a blank to the DV lists but hadn't thought of that...
Fantastic!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.