# Sumproduct with text and date conditions, Excel 2010

#### Dking131

##### New Member
Hi,

I am stuck trying to use a sumproduct with three conditions.

My objective is to count the number of dates for a specific geographical region which fall within a certian range.

'Launch Tracker'!\$H\$3:\$H\$1200 = the column reference where the region is contained e.g. Europe

The date range is greater than 7 days from today for which I have a cell reference B1, and less than todays date (cell reference B2) +30 days

'Launch Tracker'!\$AB\$3:\$AB\$1223 is the column where the dates are contained

The current formula I am using is: =SUMPRODUCT(('Launch Tracker'!\$H\$3:\$H\$1200="Europe")*('Launch Tracker'!\$AB\$3:\$AB\$1223>\$B\$1)*('Launch Tracker'!\$AB\$3:\$AB\$1223<\$B\$2+30))

The value being returned is: #N/A

I have also tried: =SUMPRODUCT(--('Launch Tracker'!\$H\$3:\$H\$1200="Europe"),--('Launch Tracker'!\$AB\$3:\$AB\$1223>\$B\$1),--('Launch Tracker'!\$AB\$3:\$AB\$1223<\$B\$2+30))

Which returns: #VALUE!

Any suggestions greatly appreciated?

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### VoG

##### Legend
Try

=SUMPRODUCT(--('Launch Tracker'!\$H\$3:\$H\$1223="Europe"),--('Launch Tracker'!\$AB\$3:\$AB\$1223>\$B\$1),--('Launch Tracker'!\$AB\$3:\$AB\$1223<\$B\$2+30))

#### Dking131

##### New Member
This worked!
So I understand for future do all referenced Column lengths need to be the same?

#### VoG

##### Legend
Yes, the ranges must be identical in size.

#### Robert Mika

##### MrExcel MVP
As you are using Excel 2010:
=COUNTIFS('launch tracker'!\$H\$3:\$H\$1223,"Europe",'launch tracker'!\$AB\$3:\$AB\$1223,">"&\$B\$1,'launch tracker'!\$AB\$3:\$AB\$1223,"<"&\$B\$2+30)

Replies
0
Views
245
Replies
2
Views
232
Replies
0
Views
224
Replies
5
Views
376
Replies
0
Views
439

1,195,848
Messages
6,011,949
Members
441,657
Latest member
Diupsy

### 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.

### Which adblocker are you using?

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

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