Im pretty good with Excel formulas but not pro enough for this.

Is there a way to write a formula that will search for all instances of a certain date on a sheet and if it finds the date, it will take the cells value next to it and add them together?

Hi DrJizzle. Does it have to be a cell formula? It might be easier to do in visual basic for applications, which should be built into excel.

Let me know if you need help with this.

Yes. Is this correct

Colb, seems to have the answer. But another way to do this is by using a query. You can create a query that Groups by Date and Sums the value for that date. You can then filter by the date.

Did I mention that VBA is more fun?

Yeah VBA seems to be where I will have to do it. However, I have absolutely no experience with that. Let me tinker with it and see what I can figure out. Otherwise, I shall return bwahah lol

Thanks all!!