Hi,

I have produced a formula in Excel 2007 that returns the value either 1 or 0
in cell A1 depending upon various criteria.

I am trying now to count how many times these criteria are met by counting
the number of times the cell A1 returns the value 1.

I thought that using the formula =If(A1=1,B1+1,B1) would work but so far I
seem to be missing something. Any help here would be great.

Thanks.

Do you mean to say that Col A either has 1 or 0 in different rows as a result
of your criteria...?

In that case you can simply use
=SUM(A1:A100)

If you want to coung how many cells contain TEST in Col B then use
=COUNTIF(B1:B100="TEST")

"Highbury 1" wrote:

Hi,

I have produced a formula in Excel 2007 that returns the value either 1 or 0
in cell A1 depending upon various criteria.

I am trying now to count how many times these criteria are met by counting
the number of times the cell A1 returns the value 1.

I thought that using the formula =If(A1=1,B1+1,B1) would work but so far I
seem to be missing something. Any help here would be great.

Thanks.