Thread
:
occurance of numbers in cell range
View Single Post
#
8
Dillenger
Posts: n/a
This is exactly what I need. Thank you all for your help :)
"Ola" wrote:
...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