Summing in Line Graph or Changing What Dragging a Formula does?

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!

Put the dates in another column, eg in D3 you can enter your first date and then in D4 you can have this:

=D3 + 1

then copy this down. Then your SUMIF formula would be:

=SUMIF(A$3:A$500,D3,B$3:B$500)

then you can copy this down.

Hope this helps.

Pete

Pete, seriously, you are my hero today. Thank you so much and have a great week!