vijaymehta
New Member
- Joined
- Apr 3, 2010
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hi,
I have a small issue, I am trying to build up a household expense summary for my personal use.
I am using one tab to store all the transactions (date, expense head, mode of payment and amount) and on other tab I am trying to build the summary. I am using sumif to add transaction for summary tab. But how do I filter on date as well. I am not used to macros, so eager to know, if I can use any formulae to filter the date as well.
Thanks,
Vijay
I have a small issue, I am trying to build up a household expense summary for my personal use.
I am using one tab to store all the transactions (date, expense head, mode of payment and amount) and on other tab I am trying to build the summary. I am using sumif to add transaction for summary tab. But how do I filter on date as well. I am not used to macros, so eager to know, if I can use any formulae to filter the date as well.
Thanks,
Vijay