![]() |
#1
|
|||
|
|||
![]()
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! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
taryn | Excel | 2 | 01-23-2015 05:41 AM |
![]() |
akatz85 | Excel | 4 | 03-27-2014 08:46 PM |
![]() |
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 |
![]() |
aleksandr | Excel | 10 | 05-18-2009 12:14 PM |