I am looking to implement a UDF using ExcelDNA for something similar to SUMIFS. I want to have a variable number of critera_range,criteria pairs, but I can't find a good way to do this without explicitly adding a chosen number of these pairs as arguments or just using params and getting a bunch of objects; the latter is nice, but there isn't anything there besides a description using IntelliSense to inform the user that pairs of values are required. Is it possible to do this using ExcelDNA?

0 Answers