Excell formula
It has been awhile since i worked on advanced formulas in excel.
I am working on a budget sheet and am having trouble on a formula to sum numbers in column F based on a range of numbers (a week of rows) in column E that can be extended to other rows (drag fill) to get a dollar amount needed for a specific day. This is what i have as of now;
=IF E3:E40,>=H46-1,and<=H46+5,SUM(F3,F40)
E is the due date column in a table
H is the reference date outside the table with the range (minus a day and plus 5 days)
F is the column of numbers in the table i want summed.
So if i put in 15 in cell H, i would like it to sum the numbers in column F that are in the range of 14-20 in column E.
Is it possible to get it to wrap around back to 1 since there are no more than 31 days in a month, rather then the range increasing to 35?
It has been awhile since i worked on advanced formulas in excel.I am working on a budget sheet and am having trouble on a formula to sum numbers in column F based on a range of numbers (a week of rows) in column E that can be extended to other rows (drag fill) to get a dollar amount needed for a specific day. This is what i have as of now;=IF E3:E40,>=H46-1,and<=H46+5,SUM(F3,F40)E is the due date column in a tableH is the reference date outside the table with the range (minus a day and plus 5 days)F is the column of numbers in the table i want summed. So if i put in 15 in cell H, i would like it to sum the numbers in column F that are in the range of 14-20 in column E.Is it possible to get it to wrap around back to 1 since there are no more than 31 days in a month, rather then the range increasing to 35? Read More