Hi, I'm using an index match but this doesn't sum all the values i need for Sales Department, i've been messing around adding SUM at the beginning of the formula but that adds everything in that column
The attachment shows the basic formula but that returns the first value it finds.
Can anybody help?
The attachment shows the basic formula but that returns the first value it finds.
Can anybody help?