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.
I like this formula, how would I modify this formula for a third and fourth category to sort?
Example from the sheet attached.
I have another set of data where, out of the sum collected with your formula, I need the singular sum total of items that correspond to a certain language and/or type. Which is why I used SumIF
For example for US on the specified date:
=SUMPRODUCT(B4:C10*(B3:C3=A1)*(F4:F10="US"))
See the attached version.