sureshsonti
Member
Hello,
I am trying to add values from a table based on account numbers. For example I have data like this
Date Acct Amount
1/1/2018 1500-00 1500
1/15/2018 1500-01 2000
2/15/2018 1500-03 1000
Output for January
Acct Amount
1500-00 + 1500-01 3500
If I type 1500-00 + 1500-01 in a cell I should get the 3500 value for January. The date criteria should also be considered
Thanks for your help. I have attached a sample file
I am trying to add values from a table based on account numbers. For example I have data like this
Date Acct Amount
1/1/2018 1500-00 1500
1/15/2018 1500-01 2000
2/15/2018 1500-03 1000
Output for January
Acct Amount
1500-00 + 1500-01 3500
If I type 1500-00 + 1500-01 in a cell I should get the 3500 value for January. The date criteria should also be considered
Thanks for your help. I have attached a sample file