Counting results of a formula
in [Functions]
|
Prev: copied from web page to excel sheet and cant remove from sheet
Next: Count, Sum, Index,Match or other formula needed
From: Nadine on 4 May 2010 13:10 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.
From: Gord Dibben on 4 May 2010 13:27 =COUNTIF(G1:G111,">""") Gord Dibben MS Excel MVP On Tue, 4 May 2010 10:10:01 -0700, Nadine <Nadine(a)discussions.microsoft.com> 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.
From: Bob Umlas, Excel MVP on 4 May 2010 13:43 =SUMPRODUCT(N(A1:A111<>"")) Bob Umlas Excel MVP "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.
From: Nadine on 4 May 2010 14:26 I get the #NUM result. Thanks for trying. "Bob Umlas, Excel MVP" wrote: > =SUMPRODUCT(N(A1:A111<>"")) > Bob Umlas > Excel MVP > > "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.
From: Bob Umlas, Excel MVP on 4 May 2010 15:41
The formula can't produce #NUM unless the range already has a #NUM in it. Are you sure you entered it as written? "Nadine" wrote: > I get the #NUM result. Thanks for trying. > > "Bob Umlas, Excel MVP" wrote: > > > =SUMPRODUCT(N(A1:A111<>"")) > > Bob Umlas > > Excel MVP > > > > "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. |