Jun 26 2022 12:19 AM - edited Jun 26 2022 12:25 AM
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..
Jun 26 2022 12:47 AM
Solution= 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)
Jun 26 2022 01:05 AM
=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.
Jun 28 2022 11:55 AM
You are welcome. Glad the suggestion was helpful.
Jun 26 2022 12:47 AM
Solution= 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)