D
Darrell
Thanks for the help. I like that way a lot better. I actually got a
formula to work, and it probably follows along with the suggested
earlier. It is written with the names of the tabs I had to use, but
maybe someone else will be able to use it. Again, thanks to everyone.
=SUMPRODUCT(--('Call Frequency'!$A$1:$A$50000<>"")/COUNTIF('Call
Frequency'!$A$1:$A$50000,'Call Frequency'!$A$1:$A$50000&""),--('Call
Frequency'!$C$1:$C$50000='Repeat Model Type Breakdown'!A2))
formula to work, and it probably follows along with the suggested
earlier. It is written with the names of the tabs I had to use, but
maybe someone else will be able to use it. Again, thanks to everyone.
=SUMPRODUCT(--('Call Frequency'!$A$1:$A$50000<>"")/COUNTIF('Call
Frequency'!$A$1:$A$50000,'Call Frequency'!$A$1:$A$50000&""),--('Call
Frequency'!$C$1:$C$50000='Repeat Model Type Breakdown'!A2))