UDF for sum of multiple criteria in multiple columns and single criteria in multiple colum

Hi Experts,

I am trying to get sum based on multiple criteria from 3 columns and single criteria from 1 columns and got the formula from “Excel Formulas & Functions” forum. However it is not working if criteria mentioned as "*" (means for all records in database).

e.g. Earlier in sumifs function i used "*" as criteria for sum of all the records in database, have created dynamic drop-downs for selection of criteria/options for end user to view the summary of data.

Is there any UDF to get sum based on multiple criteria in multiple columns and single criteria multiple columns......

Please check the attached file for details.

Any help highly appreciated.