![]() My question is: what formula's can calculate the number of observations in variables columns B and C? Any help is greatly appreciated. Also, the order of variables might not be the same. It is possible that in the variables sheet, there are comments in between different variables (although never in in column A this column holds either a variable name or is empty). Looking solely at banks ( SECTOR = 'Bank') there are 2 observed values ( 5 for ING and 0 for BofA). ![]() Looking at the companies sheet, there are 4 observations for this variable ( 7, 5, 0 and 5). In the sheet below, (1) is in column B, (2) in column C: I need (1) an overall count of the number of observations and (2) the number of observations for companies that are in the banking sector. I need to know how many observations I have for each VAR. There are many missing values (empty cell is missing value, 0 actually is an observed value). ![]() This sheet holds hundreds of VARs for thousands of companies.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |