FAO: Roger Govier - COUNTIF v COUNTA

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

Bob Phillips

Roger,

A week or so ago we discussed which is quicker, COUNTA(rng) or
COUNTIF(rng,"<>"). I said I would benchmark it.

As suspected COUNT is quicker. I set up 15,000 cells for each function, the
first run tested against a whole column (=COUNTA(A:A)), the second against
part of a column (=COUNTA(A1:A5000)). In both tests, the COUNTA came out at
over 4 times as quick as COUNTIF.


Regards

Bob
 
Hi Bob

Thanks for that. I will ensure that I make use of COUNTA whenever I can now,
as opposed to COUNTIF. That's quite a difference.

Regards

Roger Govier
 

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

Using COUNTA for a variable array 5
VBA for data validation in 3rd column does not run. I need help. 1
Statement to Automate new sheets if is needed it. 3
remove duplicates macro ending sub 8
Makulu Mate v Mint Cinnamon v Zorin shootout. 3
Ziff-Davis Benchmarking Operation 1
w00t...problem solvered 1
The Man Who Spilled the Secrets =haxored 5

Back
Top