Thread
:
occurance of numbers in cell range
View Single Post
#
7
Ola
Posts: n/a
....and that should be...
=SUMPRODUCT(--( (A1:A3 & B1:B3 & C1:C3) = (A1 & B1 & C1) ) )
I added a few " " to make it easier to read.
Ola
Reply With Quote