I have inherited an Excel database that looks somethign like this. I can't change the structure of the database since employees in the field are currently using it on a project.
The employee enters a company name in the first column. In the response column, the employee enters a 1 for the correponding response, and all other responses are marked as 0. In the field marked ???? I need to return a number such as "How many employees entered IBM as a company and 3 as a response?" The only function that I can think to use is CountIf, but how can I enter multiple parameters with CountIf? I could use VBA but the list of companies and possible responses is huge.
and while I am here, anyone know why those two tab characters are showing in C10 and D10?
Thanks!!
The employee enters a company name in the first column. In the response column, the employee enters a 1 for the correponding response, and all other responses are marked as 0. In the field marked ???? I need to return a number such as "How many employees entered IBM as a company and 3 as a response?" The only function that I can think to use is CountIf, but how can I enter multiple parameters with CountIf? I could use VBA but the list of companies and possible responses is huge.
and while I am here, anyone know why those two tab characters are showing in C10 and D10?
Thanks!!
Pasta1.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Company | Response1 | Response2 | Response3 | ||
2 | IBM | 1 | 0 | 0 | ||
3 | HP | 0 | 1 | 0 | ||
4 | IBM | 0 | 1 | 0 | ||
5 | IBM | 1 | 0 | 0 | ||
6 | Dell | 0 | 0 | 1 | ||
7 | Dell | 0 | 0 | 1 | ||
8 | IBM | 0 | 1 | 0 | ||
9 | Dell | 1 | 0 | 0 | ||
10 | Total | ???? | ||||
Plan3 |