Hi!

I am trying to make a formula where I add up dollar amounts based on which
rows have a certain date.

I have a spreadsheet where I keep track of my sales for the day and I want
to add up my total sales in different categories for each day. Each
transaction is in a row and is dated. I have the workbooks split up into
type of sale instead of date so I need to find a way to have excel choose the
amounts based on the date given in another cell in the row.

Anyone know how to do this?

Thanks in advance!