Forum Discussion
GilesH14
Mar 13, 2024Copper Contributor
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? ...
Detlef_Lewin
Mar 13, 2024Silver Contributor
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.