| 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) |
| 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) | |||
Threaded Mode
