sumifs between 2 specific dates entered.
 

I am having a problem in writing a function for a multiple spread sheet
workbook that involves dates, qty, and customers. What I what to do is type
in a date range (beginning in one box and ending in another) to produce a
listing sum of the qtys by customer.

This is what I have but I am not doing something right.

=SUMIFS('Master Listing'!D:D,('Master Listing'!N:N,"="$N$35,'Master
Listing'!N:N,"<=$O$35"),'Master Listing'!C:C,B6)

sumifs between 2 specific dates entered.
 

Try
=SUMPRODUCT(('Master Listing'!N:N=$N$35)*('Master Listing'!N:N<=$O$35)*
('Master Listing'!C:C=B6),'Master Listing'!D:D)

If this post helps click Yes
---------------
Jacob Skaria


"GEO" wrote:

I am having a problem in writing a function for a multiple spread sheet
workbook that involves dates, qty, and customers. What I what to do is type
in a date range (beginning in one box and ending in another) to produce a
listing sum of the qtys by customer.

This is what I have but I am not doing something right.

=SUMIFS('Master Listing'!D:D,('Master Listing'!N:N,"="$N$35,'Master
Listing'!N:N,"<=$O$35"),'Master Listing'!C:C,B6)

sumifs between 2 specific dates entered.
 

Try it like this (all on one line):

=SUMIFS('Master Listing'!D:D,'Master Listing'!N:N,
"="&'Master Listing'!N35,'Master Listing'!N:N,
"<="&'Master Listing'!O35,'Master Listing'!C:C,
'Master Listing'!B6)

--
Biff
Microsoft Excel MVP


"GEO" wrote in message
...
I am having a problem in writing a function for a multiple spread sheet
workbook that involves dates, qty, and customers. What I what to do is
type
in a date range (beginning in one box and ending in another) to produce a
listing sum of the qtys by customer.

This is what I have but I am not doing something right.

=SUMIFS('Master Listing'!D:D,('Master Listing'!N:N,"="$N$35,'Master
Listing'!N:N,"<=$O$35"),'Master Listing'!C:C,B6)

sumifs between 2 specific dates entered.
 

Ooops!

I used the wrong cell refs for the date boundaries:

=SUMIFS('Master Listing'!D:D,'Master Listing'!N:N,
"="&N35,'Master Listing'!N:N,"<="&O35,
'Master Listing'!C:C,'Master Listing'!B6)


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try it like this (all on one line):

=SUMIFS('Master Listing'!D:D,'Master Listing'!N:N,
"="&'Master Listing'!N35,'Master Listing'!N:N,
"<="&'Master Listing'!O35,'Master Listing'!C:C,
'Master Listing'!B6)

--
Biff
Microsoft Excel MVP


"GEO" wrote in message
...
I am having a problem in writing a function for a multiple spread sheet
workbook that involves dates, qty, and customers. What I what to do is
type
in a date range (beginning in one box and ending in another) to produce a
listing sum of the qtys by customer.

This is what I have but I am not doing something right.

=SUMIFS('Master Listing'!D:D,('Master Listing'!N:N,"="$N$35,'Master
Listing'!N:N,"<=$O$35"),'Master Listing'!C:C,B6)

sumifs between 2 specific dates entered.
 

"=" should be within double quotes and the cell reference attached using &

=SUMIFS('Master Listing'!D:D,'Master Listing'!N:N,"=" & $N$35,
'Master Listing'!N:N,"<=" & $O$35,'Master Listing'!C:C,B6)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try
=SUMPRODUCT(('Master Listing'!N:N=$N$35)*('Master Listing'!N:N<=$O$35)*
('Master Listing'!C:C=B6),'Master Listing'!D:D)

If this post helps click Yes
---------------
Jacob Skaria


"GEO" wrote:

I am having a problem in writing a function for a multiple spread sheet
workbook that involves dates, qty, and customers. What I what to do is type
in a date range (beginning in one box and ending in another) to produce a
listing sum of the qtys by customer.

This is what I have but I am not doing something right.

=SUMIFS('Master Listing'!D:D,('Master Listing'!N:N,"="$N$35,'Master
Listing'!N:N,"<=$O$35"),'Master Listing'!C:C,B6)