SOLVED

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

@Zain123 

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

@Zain123 

=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

@Zain123 

You are welcome. Glad the suggestion was helpful.