Hello All
I have the following layout
I'm having trouble with my SUMIFS.
If the cell in column W is blank, then the numbers in column X would be added in column Y, based upon the two dates of 1-3-2022 & 1-4-2022.
then the SUMIFS would continue with the next set of two dates of 1-4-2022 & 1-5-2022....and so on to the bottom of the data set.
So in this example, cellY3 would equal 1957.61 based upon the first date of 1-3-2022.
Is this possible?
Thank you
The formula I am using is:
I have the following layout
I'm having trouble with my SUMIFS.
If the cell in column W is blank, then the numbers in column X would be added in column Y, based upon the two dates of 1-3-2022 & 1-4-2022.
then the SUMIFS would continue with the next set of two dates of 1-4-2022 & 1-5-2022....and so on to the bottom of the data set.
So in this example, cellY3 would equal 1957.61 based upon the first date of 1-3-2022.
Is this possible?
Thank you
The formula I am using is:
VBA Code:
=SUMIFS(X:X,T:T,"",AA:AA,AND(AA3,AA4))