Results 1 to 3 of 3

Thread: sumif with date range help sos please help

  1. #1

    sumif with date range help sos please help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Screen Shot 2012-10-17 at 7.45.19 PM.jpg 
Views:	23 
Size:	101.7 KB 
ID:	847   Click image for larger version. 

Name:	Screen Shot 2012-10-17 at 7.45.51 PM.jpg 
Views:	18 
Size:	98.7 KB 
ID:	848  

  2. #2
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    Can you add the file?
    It will be much more easier for me to analyze the sheet

  3. #3
    Quote Originally Posted by eisayev View Post
    Can you add the file?
    It will be much more easier for me to analyze the sheet
    thank you for replying. i figured it out. i think.......

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •