SOLVED

Question related to Sum

Iron 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 (Iron Contributor)
Solution

@Excel 

= SUBTOTAL( 109,A1:A10)

 

File with the example added.

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

@Excel 

=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

@Excel 

You are welcome. Glad the suggestion was helpful.

1 best response

Accepted Solutions
best response confirmed by Excel (Iron Contributor)
Solution

@Excel 

= SUBTOTAL( 109,A1:A10)

 

File with the example added.

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

View solution in original post