For example starting at A4 I have a column of dates, some of which are repeated randomly throughout the column. also starting at C4 I have a column with numbers in, related to each date.
I would like to find each instance of the same date and add the corresponding values together, placing the cumulative value against the first instance of the date.
Hope that makes sense.
regards
Last edited by sipa; 10-27-2014 at 01:14 PM.
sounds like a sumif stmt would work. for example, you have in col A dates, you could take the list of dates and copy them to another empty column then use remove duplicates and get a short single list. Then using that list put in another column =sumif(A:A,[the cell with your first date value],C:C) that would give you a sum for all the specific dates in your list.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
This should do as you want.
Adjust as necessary for the range of data that you have.
Formula:
Please Login or Register to view this content.
The COUNTIF identifies if the entry in column A is the first time that entry has been encountered and if it is performs the SUMIF calculation. Subsequent encounters with the same date will result in a blank cell. This continues down the column for each new entry encountered by the COUNTIF.
Last edited by newdoverman; 10-27-2014 at 03:49 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks forr the quick reply's
Newdoverman, thank you, works great!
You're welcome and thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks