UDF to sumproduct with filtered data only

Hello everyone
I need a UDF function that enables me to sum with conditions but the sum process for visible rows only after filter mode
This is an example of the formula

Please Login or Register  to view this content.

All what I need UDF to enable me to do sumproduct function with visible rows only.
The filter would be in several columns .. may be one column to be filtered.. may be two .. May be three or more
I need something flexible to achieve that

This is a sample workbook

Hi,

If the hidden rows is caused by applying filter(s) (by AutoFilter or AdvancedFilter), and not by set them manually by hand, then you don't need UDF at all. All that you need is SUMIFS() or SUMPRODUCT() formula (and you are already using it).

Even if you set the rows hidden manually, you can still use the SUMIFS() or SUMPRODUCT() with a helper column.

For example, your current function :

Formula:

Please Login or Register  to view this content.

Put this function on Data!M3 and copy down:

Formula:

Please Login or Register  to view this content.

Then replace the sum range in the original function with this helper column :

Formula:

Please Login or Register  to view this content.

---------------------------------------

But if you insist to use an UDF, this is the code :

Please Login or Register  to view this content.

I set the parameter syntax of this function is exactly the same as parameter of SUMIFS() formula, that is :
- The first parameter is the range of area to be summed
- The follower parameter is pair(s) of "Range - Criteria", the syntax is same as the SUMIFS() formula

For example :

Formula:

Please Login or Register  to view this content.

Regards

Mr. Karedog
I have spent hours to find similar solution but I didn't find any where.. You are UNIQUE AWESOME
Thank you very much for this great and wonderful UDF
Thanks for all your help