I am using the sumifs and countifs functions to summarise data in a database.
The left column of my summary lists the values of one parameter and the
columns on the right use either the sumifs or the countifs. Above my
summary, I created two filter combo boxes where the user can select which
parameter to set as criteria_range so as to create an automated 4D summary
table.
The problem I have is that although my ifs functions correctly read the
parameters of the criteria_range from the combo boxes, they read it as a
label and not as a named range i.e. it reads the parameter as ="named_range"
instead of =named_range. I tried to convert my label to range but I couldn't
find anything suitable. Does anybody have any ideas?