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
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