I thought this was a simple formula but am not seeing the results I desire. In the attached xcel sheet there are two date columns and one count column. I am trying to match up the two date fields while then summing the one count field. There may be multiple date entries in the second date column, which is the reason to sum up the count.
Please help.
thanks
cbeck,
In cell B2, use this formula and copy down:
=SUMIF($J$2:$J$38,A2,$K$2:$K$38)
However, because the Report Date list in column A has many dates that are not in the Post Date list in column J, many results will be 0. But you can see the formula does correctly get the desired results if you look at Report Date 1/2/2011, which shows 8. That is the sum of 3 and 5, the two Post Counts associated with the Post Dates listed for 1/2/2011
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks