Event Counter
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. |
Event Counter
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. |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com