How to Use SUMIF on Date Columns After Today in a Table (not a range)

Copper Contributor

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?




3 Replies


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.





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 :D