Counting results of a formula
=COUNTIF(G1:G111,"""")
Gord Dibben MS Excel MVP
On Tue, 4 May 2010 10:10:01 -0700, Nadine
wrote:
I have a column that has about 111 rows to it. In each row is a formula that
will find an invoice number if it exists elsewhere. The are alpha-numeric
invoice #s.
I need to count the number of invoices found. If I use the COUNTA formula
for that column it will count those cells that have the fomula in it but no
result. I only want to count those cells that have a result from the
formula. Any ideas for using Excel 2003? Thanks.
|