Hi Guys
I have a formula that I am having issues with, there is a an example file here
https://app.box.com/s/08cucpffqosyiswsi15c
The formula is
=SUMIFS($D$4:$D$99983,$A$4:$A$99983,AND("=$I5","<$I5"+1),$D$4:$D$99983,J$4)
I think the AND part is rubbish.
I5 in this cell = 1
Col D will be 1, 2, 3 or N/A
Col A is 1.1 ... 1.23, 2.1 ... 2.15 etc
hope this makes sense to someone.
Martin
I have a formula that I am having issues with, there is a an example file here
https://app.box.com/s/08cucpffqosyiswsi15c
The formula is
=SUMIFS($D$4:$D$99983,$A$4:$A$99983,AND("=$I5","<$I5"+1),$D$4:$D$99983,J$4)
I think the AND part is rubbish.
I5 in this cell = 1
Col D will be 1, 2, 3 or N/A
Col A is 1.1 ... 1.23, 2.1 ... 2.15 etc
hope this makes sense to someone.
Martin