Question related to Sum

Super Contributor

Hello Everyone,


In below screenshot :


Screenshot (695).png


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 using Microsoft Office 2019 Home and Students.


Here is a attached file..

4 Replies
best response confirmed by Excel (Super Contributor)


= 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)



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.