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.