I have on sheet1 a couple thousand rows of data. A:A contains dates,
B:B contains ID numbers.
on sheet2 I need to know how many instances an ID number shows up on a
selected date. The specified ID number will be in sheet2, A2; the
specified date will be in sheet2, A1. It seems like I want a Countif,
but it only allows for one criteria as far as I know. What kind of
formula do I need for this?
Thanks.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=574454