Forum Discussion
Solved
Formula to automatically move to a new column based on date.
Hello everyone, attached is an example of the data I'm working with. What I'm having trouble figuring out is a formula that will move over automatically as the date changes with the =TODAY(). ...
For example for US on the specified date:
=SUMPRODUCT(B4:C10*(B3:C3=A1)*(F4:F10="US"))
See the attached version.
If I have Today() on A1, it produces today's current date.
In a table, I have a set of data with dates as headers and numeric data under each date.
I need help figuring out an appropriate formula to automatically sum data based on the date in the header. And that the date in the header needs to match the date in A1 ("TODAY()").
I was using a SUMIF Formula to Sum based on other criteria, but I have to adjust range being referenced in the data to reflect the data in the column under the present day represented in the header.
Hope that makes sense.