Best if you can upload a file with an example of your data and the result that is expected. Otherwise look into using the SUMIFS function as that's the one that allows for multiple criteria.

Strange, I did upload an example file. but doesn’t seem to uploaded. Will try again 

@jjmadness 

Oh yes! Now I see the file above your first post. Didn't notice that. Sorry.

Please find a solution in the attached file. It's a bit clunky and requires a modern Excel version that supports the LET function. Let me know if it works for you.

Hello there, thank you so much,

I apologize for the confusion. I should have provided a clearer example sheet, see attached above. I actually don’t need to include the sub-format in Column B; I only need to sum the total from Column A and the values in Column C. Therefore, there are two rows for body wash and two rows for deodorant in the sum range highlighted in yellow. How can I sum the values from these two rows using the LET formula? I assumed to replace sum to sumifs? 

Thanks

@jjmadness 

OK, then you need the FILTER function inside the LET. That allows you to 'pick-up' multiple rows. Then TAKE and DROP to narrow down the SUM range. See attached.

@jjmadness 

As an alternative, I would personally favour flattening the data with Power Query and then create a summary with a simple Pivot Table where you select the periods in a slicer.

Even better if you use real month start and -end dates, rather texts like "2024 C1". Then you can use some of Excel's inbuilt time intelligence to create dynamic reports. Your choice.

@riny Thank you so much, really appreciated.