maryworthington
New Member
- Joined
- Apr 15, 2008
- Messages
- 11
Hello,
Have a sheet that I'm trying to do some calculations but failing miserably at it
<tbody>
</tbody>
Created another sheet with just column A without the duplicate names
trying to count each instance of A with date =>6/17/2016
<tbody>
</tbody>
=COUNTIF(Sheet1!B:B,">=6/17/2016") something along that but not sure how to do the search/match based on column A?
Thanks
Mary
Have a sheet that I'm trying to do some calculations but failing miserably at it
A | B | |
1 | Acme | 6/16/2016 |
2 | Bat | 6/20/2016 |
3 | Acme | 6/17/2016 |
4 | Acme | 6/26/2016 |
5 | Charlie | 6/25/2016 |
6 | Bat | 6/11/2016 |
<tbody>
</tbody>
Created another sheet with just column A without the duplicate names
trying to count each instance of A with date =>6/17/2016
A | B | |
1 | Acme | 2 |
2 | Bat | 1 |
3 | Charlie | 1 |
<tbody>
</tbody>
=COUNTIF(Sheet1!B:B,">=6/17/2016") something along that but not sure how to do the search/match based on column A?
Thanks
Mary