Using TODAY() in a Sheet Summary

TroyT

Capture.JPG

I am trying to get a sheet summary formula to report a cell based no todays date. I tried the following formula (and a few similar variations) with no luck. What am i doing wrong? should i be going the vlook

up route? Thanks!

=IF(Date:Date = TODAY(), [Total Completed C-Boxes]@row,"")

Jeff Reisman

@TroyT

Try an INDEX/MATCH there. I like INDEX/MATCH over VLOOKUP because it will still work even if columns get moved around in the sheet.

=INDEX([Total Completed C-Boxes]:[Total Completed C-Boxes], MATCH(TODAY(), Date:Date, 0))

In English - find the value in the [Total Completed C-Boxes] column on the row where the Date value equals today.

Jeff Reisman

@TroyT

Try an INDEX/MATCH there. I like INDEX/MATCH over VLOOKUP because it will still work even if columns get moved around in the sheet.

=INDEX([Total Completed C-Boxes]:[Total Completed C-Boxes], MATCH(TODAY(), Date:Date, 0))

In English - find the value in the [Total Completed C-Boxes] column on the row where the Date value equals today.

TroyT

So helpful, worked like a charm. thanks @Jeff Reisman !