I am trying to write a formula where there are 2 criteria, and they are dates, drawn from cells. This is what I wrote, using the formula wizard;
=SUMIFS(E46:W46,E5:W5,"<=ZG$49",E5:W5,">=ZG$52")
What I am trying to do is get the formula to examine E5:W5 and see if it is before the date in cell ZG49 or after the date in cell ZG52. I thought I could do this, using the greater than or less than function. Someone else said the quotes should be only around the mathematical portion like this "<=" or this ">=", but when I tried doing this, the formula wizard said it was invalid as a criteria.
Ideally, I want the formula to be able to change, based on me changing the dates in the 2 cells. I feel like this is simple, but every way I tried it, it wasn't working. Shouldn't the dates operate as numbers?
=SUMIFS(E46:W46,E5:W5,"<=ZG$49",E5:W5,">=ZG$52")
What I am trying to do is get the formula to examine E5:W5 and see if it is before the date in cell ZG49 or after the date in cell ZG52. I thought I could do this, using the greater than or less than function. Someone else said the quotes should be only around the mathematical portion like this "<=" or this ">=", but when I tried doing this, the formula wizard said it was invalid as a criteria.
Ideally, I want the formula to be able to change, based on me changing the dates in the 2 cells. I feel like this is simple, but every way I tried it, it wasn't working. Shouldn't the dates operate as numbers?
