I have a UDF that performs a count function based on background colour. I wish to use the UDF within an Index and Match function.
What I would like to do is for the Index function to use my UDF to sum the different colours within my sheet.
So instead of it performing say
Index(b7:T30,(match(V7,A7:A30,0),Match(W5,B5:T5,0)) and returning the value of the cell
I would like it to perform the following
Index(GetColourCount(b7:T30,V6),(match(V7,A7:A30,0),Match(W5,B5:T5,0)) and return the count of the colours
Thanks
What I would like to do is for the Index function to use my UDF to sum the different colours within my sheet.
So instead of it performing say
Index(b7:T30,(match(V7,A7:A30,0),Match(W5,B5:T5,0)) and returning the value of the cell
I would like it to perform the following
Index(GetColourCount(b7:T30,V6),(match(V7,A7:A30,0),Match(W5,B5:T5,0)) and return the count of the colours
Thanks