dschwister
New Member
- Joined
- Oct 13, 2011
- Messages
- 7
Hi All-
I am working in two worksheets. Worksheet A is where I am rolling up all of my data and Worksheet B is where I am inputting all of said data. In Worksheet A I am trying to find the number of times "david" appears in range "worksheetB A1:A100" and the number "1" in "worksheetB E1:E100". Both of these instances must occur for me to count. Does this make sense? I thought maybe a vlookup would work but it isn't. I also tried a sumproduct but that didn't work either. Any help would would be greatly appreciated!!!
What I need is for Excel to count the number of times "David" and "1" appear in the same row. David is column A and 1 would appear in column E.
I am working in two worksheets. Worksheet A is where I am rolling up all of my data and Worksheet B is where I am inputting all of said data. In Worksheet A I am trying to find the number of times "david" appears in range "worksheetB A1:A100" and the number "1" in "worksheetB E1:E100". Both of these instances must occur for me to count. Does this make sense? I thought maybe a vlookup would work but it isn't. I also tried a sumproduct but that didn't work either. Any help would would be greatly appreciated!!!
What I need is for Excel to count the number of times "David" and "1" appear in the same row. David is column A and 1 would appear in column E.