Forum Discussion
Excel
Jun 26, 2022Iron Contributor
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...
- Jun 26, 2022
= 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)
Excel
Jun 28, 2022Iron Contributor
Thank you so much sir
OliverScheurich
Jun 28, 2022Gold Contributor
You are welcome. Glad the suggestion was helpful.