Hi,
I have two formulas which both work individually but I need to combine them together into one long formula.
A) =COUNTIFS(K:K, "R",L:L, "P") ..... makes 93
b) =SUMPRODUCT((D8:D10000<>"")/COUNTIF(D8:D10000,D8:D10000&"")) ........... makes 136
If I was to use the filters to get the result I want there is 7 unique references in D which have a R in K and a P in L.
When I try to combine formula A with B i get 229 not 7.
Bookmarks