# Results in 2nd Sheet Tab Returned based on Date Range

#### ExcelSuduko

##### New Member
I have a 2 sheet workboook. Sheet tab 1 (External Comm Log) contains all of the records, currently about 500 and growing. Sheet 2 (CalcSheet) is a compilation of the results in numbers (sum), based on selected results. Compiling all of the results is easy for the whole list:

=COUNTIF('External Comm Log'!E7:E1000,"Educational")

Now I am trying to select the same type of results, but based on a date range (column A of sheet tab 1). Here is my current formula but it only returns a #NAME? error:

=PRODUCTSUM('External Comm Log'!F7:F1000,"Educational")*('External Comm Log'!A7:A1000 >="4/1/2010")*('External Comm Log'!A7:A1000 <="3/31/2011")

Any and all assistance is much appreciated. Thanks!

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Hi,

You are getting the error because any function with the name PRODUCTSUM does not exist.

Maybe SUMPRODUCT is what you are looking for.

Try.

=SUMPRODUCT(('External Comm Log'!F7:F1000="Educational")*('External Comm Log'!A7:A1000 >=4/1/2010)*('External Comm Log'!A7:A1000 <=3/31/2011))

Jai

That eliminated the naming error, but returns a result of "0". It should actually be 26. The way I have the dates called out...is that correct for defining the date "range", or just records that "equal" those 2 dates. I have the >= and <= identifiers, but am not sure about the )*( in between the date criteria.

Replies
7
Views
314
Replies
7
Views
157
Replies
3
Views
713
Replies
5
Views
250
Replies
1
Views
342

Threads
1,196,329
Messages
6,014,681
Members
441,835
Latest member
rthomas268

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

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