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.
Hi there,
I think you should follow the following formula:
=SUM(FILTER($C$4:$L$10,$C$4:$L$4=$P$3)*(($B$4:$B$10=O4)))
=SUM(FILTER($C$4:$L$10,$C$4:$L$4=$P$3)*(($B$4:$B$10=O5)))
My solution file is attached to this message.
Good luck.