Forum Discussion
How to Use SUMIF on Date Columns After Today in a Table (not a range)
Hi - I have been using SUMIF to total values in date columns in a range that are all after today's date. However having converted the range to a Table, this isn't working anymore - any ideas please? ...
=SUMIF(INDEX([Column1],1):[@Column1],">"&TODAY(),INDEX([Column2],1):[@Column2])
Does this return the intended result?
Hi - thank you for your response - in my case, each column represents a different week, as opposed to each row. I have managed to fix it though, but I did cheat - I added another row of dates above the table and referenced them in my formula instead - I then changed the font to white to hide my cheating 😄