Dynamic Named Ranges?

Hey, everyone. I'm new to Excel. Loving it !

I only wish I could figure out a problem I'm having with my Daily Budget, and was wondering if someone could help me.

Screenshot 2015-08-12 11.45.34.png

In J4:J5 my formula is:
=IF(COUNT(E5,E4,I4,I5),+SUMIF(D4,"cash",E4)-SUMIF(H4,"cash",I4)+SUMIF(D5,"cash",E5)-SUMIF(H5,"cash",I5),"")

In K4:K5 my formula is:
=IF(COUNT(E5,E4,I4,I5),+SUMIF(D4,"card",E4)-SUMIF(H4,"card",I4)+SUMIF(D5,"card",E5)-SUMIF(H5,"card",I5),"")

But as you can see, this doesn't do the trick.

On any given day, I might have more or less than two rows for Income and Expenses, and when I fill down the formula, it doesn't take this into account.

I thought Dynamic Named Ranges would be my best bet, because then I could tell the formula to take info only from the day of the month I need. I'm not sure exactly how to tell the formula to take only from the day of the month yet, but I've looked up a lot about things like Offset, Vlookup etc. and I'm confident I can get it done once I figure out how to get a Dynamic Named Range for the days of months.

Only thing is, I can't figure out how to make the Dynamic Named Ranges!? I've tried Offset Count/Counta and nothing is working for me.

Does anyone have any suggestions??

Hi,

Can you please post a sample excel file here rather than image? Use the paper clip icon to upload the file & remember to desensitize the data before upload.

http://www.excelforum.com/members/da...ch-a-file.html