Thread: Formula for sumifs with less than a date range
View Single Post
 
Old 04-14-2015, 02:00 PM
lynchbro lynchbro is offline Windows 8 Office 2010 64bit
Advanced Beginner
  
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default 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!
Reply With Quote