Notifications
Clear all
Topic starter
Hi guys,
Could anyone help me create a formula to sum the values for a selected promotion period (from a drop-down list) based on multiple criteria — for example, Body Wash in cell A19 and the result in C19 — to get the total from 2024 C1 through 2025 C5 (inclusive), rather than just two periods.
Hope this made sense
thanks
Posted : 13/08/2025 3:54 am
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.
Posted : 13/08/2025 4:13 am
Topic starter
Strange, I did upload an example file. but doesn’t seem to uploaded. Will try again
Posted : 13/08/2025 4:49 am
