Gurus,

I need a little help with a sumproduct function.

In my worksheet I have two fields that have data validation lists in them
that users will select a value from. This works just fine. The sumproduct
results change with their selections.

What I want to do, but don't know how, is to give a "all" choice when the
fields with the data validation lists are blank. In other words, if the user
doesn't choose an option in the field then they want to see all without a
filter.

My current formula is:
=SUMPRODUCT(
--(Schedule!$A$2:$A$9981=$A$8),
--(Schedule!$I$2:$I$9981=$A$9))

Thanks in advance.

Scott