SUMIFS with table and sheets

[excel_93]

I am trying to use sumifs formula between two sheets and tables, but gets error.
What have I done wrong in following formula?

=SUMIFS(Table1[Value];Table1[House];D:D;F:F;I25)

[ben_hensel]

What have I done wrong in following formula?

Three things.

=SUMIFS(Table1[Value];Table1[House];D:D;F:F;I25)

Sum Range: Table1[Value]
Criteria 1: Table1[House]
Criteria 1: D:D
Range 2: F:F
Criteria 2: I25

1) There's no guarantee that Sum Range 1, Range 1, and Range 2 are the same length. If the ranges are different sizes, the formula will throw the #VALUE! error. You need some kind of data handling to make sure these ranges are the same size; for example, if the tables are both generated off the same indexes, then they would implicitly be the same length.

2) In fact, because you're feeding an entire column (!) to Range 2, it's almost certainly much, much larger than the other two. Feeding an entire column into a function is a bad practice. This is an example of why.

3) Also, you're feeding the entire column D:D into Criteria 1. It will only assess the first value, so practically it's comparing to D1, not down column D or whatever.