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 using Microsoft Office 2019 Home and Students.
Here is a attached file..
= 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)
4 Replies
=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.
= 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)
