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?
Thanks
G
=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 😄
You are probably refering to a column header which would be number before.
Column headers in Excel tables are ALWAYS text and are ALWAYS a value and not a formula.
Just convert the text to a number value.
