Anyone have any idea!? On worksheet (A) I have a list of dates and dollar values of jobs done on those days. I have multiple jobs for the same day with different dollar amounts. Job 1 on 04/01 is $25.00. Job 2 on 03/01 is $30.00 and so on. On worksheet (B) I wanted a column to look up the date on (A) and then add the sum of all the values for that day. So i want (B) worksheet column to look through A and find the dates it equals and add up all the dollar amounts for that day. I have tried to use an if function combines with a vlookup function but it doesnt work.
Anyone have any ideas?
Thanks,
Aaron
Bookmarks