sumif with date range help sos please help

ira1983

New member
Joined
Oct 18, 2012
Messages
2
Reaction score
0
Points
0
see images

i need to create a sumif or sumifs formula to populate cell "f20,g20,h20,etc" highlighted "total base rent" based on the dates in f18 and corresponding to the other sheet if row i falls within the date range of x and y

something like if x or y is eual to f18 or less than g18 then sum column i across row 20
 

Attachments

  • Screen Shot 2012-10-17 at 7.45.19 PM.jpg
    Screen Shot 2012-10-17 at 7.45.19 PM.jpg
    101.7 KB · Views: 29
  • Screen Shot 2012-10-17 at 7.45.51 PM.jpg
    Screen Shot 2012-10-17 at 7.45.51 PM.jpg
    98.7 KB · Views: 25
Top