Building expense summary tab

[vijaymehta]

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

 

[Robert Mika]

Can you post some of your data?

you can use nested ,sum(if... statement but to give good answer is better if you provide some example