LinkBack URL
About LinkBacks
Thank you very much to both of you.
Both formulas work on the data I provided but there's issue with the =SUMPRODUCT(($A$2:$A$15=D2)/COUNTIF($B$2:$B$15,$B$2:$B$15&"")) if you change the value in B4 to match B6. Why is that?
Thank you very much to both of you.
Both formulas work on the data I provided but there's issue with the =SUMPRODUCT(($A$2:$A$15=D2)/COUNTIF($B$2:$B$15,$B$2:$B$15&"")) if you change the value in B4 to match B6. Why is that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks