You are here: HomeExcelTutorials

# Using SUMIFS with a date range

## Using SUMIFS with a date range

Price: FREE

I am trying to Sum Total(Column D), if the Date(Column A) is between Date 1(I7) and Date 2(J7) and it is in a given Area(Column J). Various Sheets are involved.
My latest attempt is shown below(but gave me an error):
=SUMIFS('Historical Data'!\$D:\$D, 'Historical Data'!\$J:\$J, AUS!A3, "<='Historical Data'\$A:\$A",AUS!I7, ">="Historical Data'\$A:\$A,AUS!J7)

Visit publisher's web-site: Using SUMIFS with a date range

Category and Tags: ExcelTutorials :

## Related Tutorials

### Sumifs function based on Date range and sales value

Free: Yes
Tags: Excel ›

Please see the attached file. I need subtotal of sale of particular date range from a column having more than one years date wise sales data.

### SUMIFS formula with date format issues

Free: Yes
Tags: Excel ›

I'm a bit stuck with a SUMIFS formula. The data range I'm referencing contains numbers such as 20110131. My SUMIFS formula says if greater than 31/12/2010 and less than 30/03/2011, etc then return a total.
The problem I have is the data range date is a number and my greater than and less than definitions are dates so the SUMIFS doesn't work.
I'm stuck with these (i.e. the data range will always be a number and the date will always be a date) but how can I overcome this?
I've tried adding cells next to the dates for use as references in > or < and used for 31/12/2010 =right(A1,4)&mid(A1,4,2)&left(A1,2) but that doesn't return what I want.

### Sumifs using large named range

Free: Yes
Tags: Excel ›

I have a named range with multiple columns:
need
Sumifs(Named_Range(A:A),Named_Range(B:B),A1)
in other words: sum numbers in the range's column A where Column B= cell A1.
Probably simple but.

### sumifs formula with > operator on a date variable

Free: Yes
Tags: Excel ›

I'm trying to use the value of dates in cells that are greater than another date value (which needs to be a variable) as my criteria for the sumifs function. How do I make it so that excel can accept this > operator with the date value?
=IF(C3="Deposit", E2-A3, IF(C3="Annual Increase", A3+SUMIFS(\$A\$2:A2, \$C\$2:C3, "Withdraw", \$D\$2:D3, >Date(YEAR(D3)-2, 12, 31)), E2))

### SumIfs Help

Free: Yes
Tags: Excel ›

I'm trying to use the SumIfs formula in VBA to only take the sum of the data in one range if it meets the criteria of the data in another range.
So I want the DM1 range to be the sum range, and Year 1 to be the criteria range, and ">1980" to be the criteria.
I have been using this, but it has not been working: ActiveCell.Formaula ="=SumIfs(DM1,Year1,">" & 1980")". This has not been working,

## Related Applications & Scripts

### Date icon component

Free: No

This is a simple component that can be added to an application showing the current date (or a selected date).
It is easily skinnable using flex css styles.

### Date Picker as3

Free: No
Tags: Flash › Excel Date and Time

- An easy to use drag and drop on text field component
- fully customisable
- Background Color
- Calendar Placement
- Date Format
- Font
- Icon Placement
- Separator
- Language
- and much more!!!

### Dreamweaver ASP Event Calendar With Database

Free: No

ASP Event Calendar with Database is a special version of the DW ASP Event Calendar adding support for MSAccess, ODBC and MSSQL databases. Dreamweaver ASP Event Calendar is an extension for Dreamweaver that allows a fast and simple insertion of this type of calendar into a webpage.
Support for MSAccess, ODBC and MSSQL databases.
Associate a floating panel to each day or range of days; the panel will show information related to these dates. Otherwise, you can assign a direct link to a date, so that your website users are automatically redirected to a specified URL when they click on a certain date.
Floating panels can be shown by either by clicking on the date, or by pointing your mouse on the date (mouse over). You can also associate both links and floating panels to each date, at the same time.
Each date can have one or more events, which can be differentiated by using independent colors, which you select yourself.
The information in the floating panels is edited using an HTML Editor, which allows to format your data to any way you like, quite simply.
All the administration and visualization is achieved using modern Ajax technologies, which renders this product user friendly and comfortable.

### Date and Time (3 sizes)

Free: No
Tags: Flash › Excel Date and Time

3 Small Handy files for you to enjoy. These 3 clocks would be brilliant for a website to go in a corner or edge of your site.

### Analog Clock with Date

Free: No
Tags: Flash › Excel Clocks

This is an analog clock which also displays the current date. There is no need to fiddle with anything as this can be dragged and dropped where you want it to go. It is possible to change the UI by going into the .fla file and changing the clock face image.