The data on each of the three sheets being processed looks like this: First of all, note that you can't use SUMIFs with a " normal " 3D reference like this: Sheet1:Sheet3 ! D4:D5 This is the standard "3D syntax" but if you try to use it with SUMIF,...
The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.