Formula Range referencing another formula

[|||||||E|||||||]

Hi Everyone,

I'm trying to replace these bolded numbers...

=SUMPRODUCT(1/COUNTIF('Monthly Bills Rec''d'!F2:F5000,'Monthly Bills Rec''d'!F2:F5000))

With the COUNTA result from this formula...

COUNTA('Monthly Bills Rec''d'!A:A)

Any help on how to do this would be greatly appreciated.

Thanks.

 

[Marcelo Branco]

You can replace F5000 with
INDEX('Monthly Bills Rec''d'!F:F,COUNTA('Monthly Bills Rec''d'!A:A))

Could you tell us what you're trying to do? To count unique values there is a more efficient formula.

M.

 

[|||||||E|||||||]

Thank you! That seems to be working.

Yes, I'm trying to find unique values in that worksheet column. I found a few other methods, but the SUMPRODUCT(1/COUNTIF...method was the only one I could get to work.