Forum Discussion
Solved
Question related to Sum
Hello Everyone, In below screenshot : I want to sum up the total sales of each year and it should be dynamic. How to do that with the help of formula? Please help.. I am usi...
= SUBTOTAL( 109,A1:A10)
File with the example added.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
=SUM(INDEX($B$3:$J$6,,MATCH(1,($B$2:$J$2=B$10)*($B$1:$J$1=$A11),0)))Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- Thank you so much sir
You are welcome. Glad the suggestion was helpful.
