Count occurence of values
 

How do I put the following into a formula?
Sheet1 each cell in column D contains 7-digit unique invoice number. I need
to insert a counter (formula) in column P for that same invoice number
appearing in Sheet2 in cells from B90 to B1570. For example: if Sheet1D2
appears 3 times in Sheet2(B90:B1570), then I need to put 3 in Sheet1P2. If
there weren't any invoices in Sheet2, then I need zero in Sheet1P2.
Thank you.

Count occurence of values
 

Try something like:

=Countif(Sheet2!$B$90:$B$1570,D2)

copied down


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125348