|
|
#1
04-14-2015, 02:00 PM
|
|||
|
|||
Formula for sumifs with less than a date range
I am trying to pull the sum of a set of daily numbers for a specific date.
In my master sheet I have a TO DATE as 02.28.15 and I want to pull any data from the other tab for all dates after that. I have the following and it is returning ZERO, when there is figures to pull =IF(B1<Sheet!2E:E,SUMIFS(Sheet2!I:I,Sheet2!A:A,C1) ,0) B1=To Date C1=Portfolio ID Sheet2!E:E=Date Ranges Sheet2!=Dollars Sheet2!=Portfolio ID Please help! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Copying "SUMIFS" formula
|
taryn | Excel | 2 | 01-23-2015 05:41 AM |
|
Restrict Date Range Calculations
|
akatz85 | Excel | 4 | 03-27-2014 08:46 PM |
|
Date Range Prompt
|
MikeWooZ | Excel | 6 | 12-04-2011 02:10 PM |
| Help needed using the serial number date with sumifs - whole office is stumped | FraserKitchell | Excel | 3 | 01-06-2010 12:24 PM |
|
Range Formula
|
aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
Windows 8 
Office 2010 64bit
Threaded Mode