I am making stock receipt register. I have in Sheet1, 'Vendor', 'From', 'Till' & 'Quantity'.
In Sheet2 I want total of 'Quantity' by selecting same 'Name', 'From' & 'Till' using filters.
Thanks in adv.
Option 2 is using Excel functions. If you're asking whether or not it can be done without adding a helper column to concatenate the values, then yes, but it would require an array formula. If you have hundreds, or thousands, of these formulas it can take a bit to calculate them all.