CountIf referring to another cell

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
 
C

CalumMurdo Kennedy

Rick C said:
=COUNTIF(A1:A10,B1)
Click to expand...

Thanks Rick, if that works I'm going to be doing some serious head slapping!



Thanks Dan, I wouldn't have thought of that.

Best Regards,


CalumMurdo Kennedy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
Excel function - countif 2
Countif contains a word in a reference cell 3
Countif statement using dates 15
Doing a countif against a substring of the range to be scanned 1
COUNTIF greater than one column and less than another 5
countif with variabel criteria? 2
Convert times to text string 3

Top