Hi,
I have created a vlookup formula that will return a value if true and a text value if false.
I then need to do a count of the number of text results however the countifs formula still reads the vlookup output as a formula.
I have tried to break down the output and using sumproduct but i keep hitting a brick wall.
Can anybody shed any light on what im missing.
I have created a vlookup formula that will return a value if true and a text value if false.
I then need to do a count of the number of text results however the countifs formula still reads the vlookup output as a formula.
I have tried to break down the output and using sumproduct but i keep hitting a brick wall.
Can anybody shed any light on what im missing.