How to use countif, sumif across two sheets where the logical test is an equivalency?
Solution 1:
Your syntax is wrong. For SUMIF you want the Range to be Sheet1!A:A, Criteria to be A1 (if that is where the single instance of the vendor ID# is held) and the Sum_range to be Sheet1!B:B.
Example Sheet2 (inside box) below where the formulae are the contents of Row6.
