@Pecoflyer - I'm having the same problem but honestly this answer is too complicated for me to wrap my mind around.



Any suggestion for my very simple case below?

** For each year (e.g. 2016) AND irrespective of how the data has been sorted, I'd like to sum up the Value & Quantity for each "Reason". I wanted the sum value to remain unchanged, irrespective of how data is sorted.

Edit Mod : related to https://www.msofficeforums.com/excel...if-report.html

Attached Files

prevent SUM value from changing, each time data is sorted differently.xlsx (8.8 KB, 8 views)

Hi
please do not hijack threads. It's better to start your own thread eventually adding a link to another thread.
I started a thread for you and added a link

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

A Pivot Table does the job

Attached Files

SUM with conditions.xlsx (12.6 KB, 9 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post