Numbers SUMIFS multiple conditions different sheet

Hi astoller,

Your first assumption is correct—and it's a small enough error that several people occasionally get it wrong it.

The comparison operator in each item,condition pair is assumed to be =. If that is true, there is no need to include the operator.

But correcting the syntax error doesn't get us out of the woods…

The culprit here is YEAR(DETAIL::A), which extracts the YEAR from a single DATE & Time value. Add a column (which may be hidden) to Detail in which you extract the year value for each row, then use that new column in place of DETAIL::A:

Formula in DETAIL::D2:               YEAR(A2)

Formula in Year Summary::B2:   SUMIFS(Detail::$C,Detail::$B,$A2,Detail::$D,B$1)

Filling the formula to other cells:

Select, Copy, Expand selection, Paste is efficient to quickly fill the dozen body cells with the formula in B2 of Year Summary:

• Select (one click) cell B2
• 
• Copy
• Shift-click on D4 to expand the selection to cells B2:D4
• Paste

Regards,

Barry

"My resulting formula looks a little different because it uses column headings rather than letters"

Using the column headers as labels is fine for the individual or group using the document. I prefer using cell addresses when analyzing documents that I've not been the author of because column B is always the second column in the table, saving me the time of searching for the column whose header label is "Amount", which could be anywhere on the table. Usinc cell addresses also removes the possibility of spelling errors tossing a spanner into the works.

Regards,

Barry