LinkBack URL
About LinkBacks
Try...
=IF(COUNTIF($E$4:$E$17,G4)=1,SUMIF($E$4:$E$17,G4,$C$4:$C$17),"")
Try...
=IF(COUNTIF($E$4:$E$17,G4)=1,SUMIF($E$4:$E$17,G4,$C$4:$C$17),"")
HTH
Regards, Jeff
Now its showing only the non repeated values and the repeated numbers are blank. Its possible to show the repeated and non repeated values in the same formula?
Last edited by Mr.Castle; 12-09-2018 at 09:45 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks