C
CalumMurdo Kennedy
Hi,
I've been using teh CountIF for a while now and one thing I would like to be
able to do is point it to another cell that contains the equation/text that
I want to use. Currently if I use =COUNTIF(a1:a10, "=b1") it looks for =B1
rather than looking for the contents of B1. This is annoying! I have set
up a macro to create the correct formula which builds the formula using a
combination of concantenation and then pasting as a value which is far from
ideal.
Does anyone know of an easier way to do this?
Best Regards,
CalumMurdo Kennedy
I've been using teh CountIF for a while now and one thing I would like to be
able to do is point it to another cell that contains the equation/text that
I want to use. Currently if I use =COUNTIF(a1:a10, "=b1") it looks for =B1
rather than looking for the contents of B1. This is annoying! I have set
up a macro to create the correct formula which builds the formula using a
combination of concantenation and then pasting as a value which is far from
ideal.
Does anyone know of an easier way to do this?
Best Regards,
CalumMurdo Kennedy