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?

 

Thanks

G

3 Replies

@GilesH14 

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.

 

@GilesH14 

=SUMIF(INDEX([Column1],1):[@Column1],">"&TODAY(),INDEX([Column2],1):[@Column2])

 

Does this return the intended result?

sumif.png

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