DSUM formula using multiple criteria

Schwab

New Member
Joined
Jul 23, 2007
Messages
3
I am using DSUM formula using multiple criteria where one of the criteria is a tag (i.e. 1=salaries; 2=taxes;3=suppliers etc) and the other criteria is date within a range of dates (i.e. between TODAY () AND TODAY()+30. I can't set this up to include the date criteria.

Please help.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
Can you post what you are trying to achieve, what will your formula do exactly?
 

Schwab

New Member
Joined
Jul 23, 2007
Messages
3
I am preparing a summary net cash flow sheet.

I have total bank balance as at TODAY () which needs to be added to (accounts receivables) or subtracted from (accounts payables) on a daily basis projecting forward 30 60 and 90 days net cash position.

Each day the sheet needs to adjust for items that move from one period of time to another.

I have organized my workbook as follows:

1. first sheet has the database or "details" here lies all my data i.e. accounts receivables and account payable.

This data is arranged as follows:

first colum is titled "code" indicated what type of item it is. It could be an expense such as salary or tax payment or out of pocket expenses. I have a different code for each type of expense or income. For example travel expenses is code =1, salary =2 etc.
Next to each item there is the amount and the date the payment is due.

I want to summarize my data so that there are subtotals for each category of payable/receivable. Thus I need to add rows that all have the same "code" but divided up based on dates i.e. payable within 30 days; payable within 60 days and payable within 90 days.

I want to set it up so that all I have to do is type in new items to the "details" list by entering in the code, amount and date payable and the sheet calculates subtotals and totals automatically. When I need to report net cash all I do is go to my online bank account and enter in the cash balance on that day to the excel sheet and automatically I can present the net cash position for 30/60/90 days.

The only problem I am having is setting up the date criteria so that the sum is only on those amounts whereby the code is the same for example 1 and the dates fall within the range FROM TODAY() TO TODAY()+30. THANKS DANIEL

Please let me know what email address I can send the excel sheet to.
 

Schwab

New Member
Joined
Jul 23, 2007
Messages
3
After all that explanation the bottom line is to sum up dollar amounts of items that are have the same code and fall within a 30 day period from TODAY(). Thanks, Daniel S daniel.schwab @ kayema.com
 

Forum statistics

Threads
1,181,734
Messages
5,931,731
Members
436,800
Latest member
abowalid98

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top