I have a spreadsheet which contains a list of drawings recieved and I need to know how many unique drawings there are. The list of drawings is on one sheet with a summary page on a 2nd sheet.
Using the following works
=SUMPRODUCT(1/COUNTIF('Document Review'!M6:M129,'Document Review'!M6:M129))
However because the list is constantly growing I want to find a way of having the range to be automatic, or at least semi automatic.
Have tried entering the first and last row in cells c3 & c4.
I know that this works
=COUNTIF(INDEX('Document Review'!M:M,C3):INDEX('Document Review'!M:M,C4),"*")
but this doesn't
=SUMPRODUCT(1/COUNTIF(index('Document Review'!M:M,c3):index('Document Review'!M:M,c4))
Can anyone help - please
Bookmarks