PDA

View Full Version : If dates match then add



Djblois
06-24-2009, 06:49 AM
I need to do a really complicated formula that compares two dates and then if the date matches than it needs to add it. That is not the hard part. The hard part is that it needs to keep comparing dates in a column and only add if it matches. In the file I sent what it needs to do is compare the dates in the itemized Misc. Expenses Column and if they match the dates that show up above the days in the week than add it below the day. So basically they can itemize and Mondays expenses and Tuesdays will be filled in for them. If you look at what I sent it will be easier to understand.

georgiboy
06-24-2009, 07:10 AM
Like this...

Djblois
06-24-2009, 09:47 AM
That was exactly what I wanted. Easier than I thought. What would I do if I had to match too cells. Example I want to do the same thing with meals. So i put in cells with meal name. I want to add to the appropriate cell if the date matches the top again and if the meal name matches the names on the right. Is this possible?

georgiboy
06-24-2009, 10:46 AM
Like this...