| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS formula using dates and text as criteria | Excel Discussion (Misc queries) | |||
| SUMIFS and dates | Excel Worksheet Functions | |||
| sumifs, sumif with dates | Excel Worksheet Functions | |||
| SUMIFS with dates | Excel Worksheet Functions | |||
| How to make other cells give a specific value when entered into a | Excel Discussion (Misc queries) | |||
Linear Mode
