I have a list of dates G4:G14 related to a range E4:E17 dates. C4:C17 are a list of numbers related to E4:E17 dates, some of those dates are repeated. The formula must find identify only repeated dates E4:E17 and add C4:C17 numbers, showing the results of G4:G14(Dates which are not repeated) in H4:H14. So if G4 is 10/11/2018 and E4 is 10/11/2018, E5 is 10/11/2018 and C4 is 11 and C5 is 24 than H4 (related to G4 ) =35.
This is a sample workbook.
How about in H4 copied down...
=IF(COUNTIF($E$4:$E$17,G4)>1,SUMIF($E$4:$E$17,G4,$C$4:$C$17),"Not Repeated")
HTH
Regards, Jeff
The formula worked perfectly ,
Thankyou Jeff
Its possible to instead of "Not Repeated" show the non repeated numbers. If the numbers are repeated than it will add otherwise just show the non repeated numbers in G4. Sorry to bother you jeff and Thanks again.
You are very welcome. Happy to help.
Try...
=IF(COUNTIF($E$4:$E$17,G4)>1,SUMIF($E$4:$E$17,G4,$C$4:$C$17),TEXT(G4,"mm/dd/yyyy"))
Last edited by jeffreybrown; 12-08-2018 at 10:15 PM.
When the numbers are not repeated the formula is showing "mm/dd/yyyy" instead of the non repeated number. I attached a sample workbook with an example.
Try...
=IF(COUNTIF($E$4:$E$17,G4)=1,SUMIF($E$4:$E$17,G4,$C$4:$C$17),"")
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.
Sorry, I just went by the example you posted and the repeated values were blank in column I.
Anyway, this should do it...
=IF(COUNTIF($E$4:$E$17,G4)=1,SUMIF($E$4:$E$17,G4,$C$4:$C$17),SUMIF($E$4:$E$17,G4,$C$4:$C$17))
The formula worked ,
Thank you very much for your help.
You are very welcome Mr. Castle. Happy to help and thanks for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks