Hello Everyone!

I hope your week is going well! I'm having a problem with a graph I need to create. It has to be a line graph because a scatter plot will not really allow me to put dates on the X-axis like a line graph will. Anyway, in column A I have a list of dates from the start of the year to the end of the year. Some of the dates are duplicates (intentionally). Every single date has a corresponding number in column B. I'm trying to put the date on the X-axis and numbers in the Y-axis. The problem is, since there are duplicate dates there are multiple points over one date but what I really need is the sum of all of those values for the date. I tried to create a third column with a SUMIF statement telling it to add up only the values for that date but excel won't change the date when I drag the formula down the column it just changes the range that it will analayze. For example:

=SUMIF(A3:A500,"=01/10/12",B3:B500)

When I drag this down it becomes

=SUMIF(A4:A501,"=01/10/12",B4:B501)

So, is there a way to either:

1. Get the graph to just put a point on the sum of all the values for that date

or

2. Get it so that I don't have to manually change the SUMIF for 365 cells.

Thank you for any help you can offer. It is very much appreciated.

Have a wonderful day!