Hi,
Here is the basic idea. I have a column of boolean excel data that returns 'Y' or 'N'. (i.e. =IF(G2>=10,"Y","N"
) I would like to create a new column that counts the cells where the value that is returned is equal to 'Y'. The range however is not the entire column of cells. I would like to count i.e. cells A1,A122,A456,A723 where the value returned is 'Y'. Therefore the new field would be a value between 0 and 4. I thought this would be simple but I must be using the wrong syntax. Any help would be greatly appreciated. Thanks.
Brent
Here is the basic idea. I have a column of boolean excel data that returns 'Y' or 'N'. (i.e. =IF(G2>=10,"Y","N"
) I would like to create a new column that counts the cells where the value that is returned is equal to 'Y'. The range however is not the entire column of cells. I would like to count i.e. cells A1,A122,A456,A723 where the value returned is 'Y'. Therefore the new field would be a value between 0 and 4. I thought this would be simple but I must be using the wrong syntax. Any help would be greatly appreciated. Thanks.Brent
