Formula needed

Hi HD,

HD wrote:

That formula in cell A2 of table B:

SUMIFS($Donation,Table 1::A,"="&A2,$Month,"="&B1)

Though I cannot for the life of me get it to fill down or across correctly, so I had to tweak the formulae in the other 7 cells manually.

Absolute references ($ symbols) should be:

Formula in B2 of Table 2 =SUMIFS(Table 1::$C,Table 1::$A,$A2,Table 1::$B,B$1)

That will fill right and fill down 😉.

Also, I used Column & Row references instead of Column & Row labels.

Also, SUMIFS does not need ,"="& (the = is implicit).

Also, I entered the month names in both tables as text to prevent Numbers changing them to Date & Time. That will make the document work for any single year (but not for multiple years).

Regards,

Ian.

Here's one way of calculating the total for each partner:

That formula in cell A2 of table B:

SUMIFS($Donation,Table 1::A,"="&A2,$Month,"="&B1)

Though I cannot for the life of me get it to fill down or across correctly, so I had to tweak the formulae in the other 7 cells manually.

The totals in Row 6 of table 2 are just the columns summed:

Hope it helps.

For "Donation" in the equation read "Amount". 🙄

Brilliant, thanks Ian.