Formula - Columns vs Rows for multiple cell selection

[wheels8]

I've been reading a lot of posts about incrementing columns rather than rows, however I've not seen anything for selecting multiple cells.

Here's what I have so far:

=SUM(Sheet2!D4,Sheet2!D16,Sheet2!D21,Sheet2!D25,Sheet2!D34,Sheet2!D60,Sheet2!D76,Sheet2!D79,Sheet2!D80,Sheet2!D89,Sheet2!D111)

What I want it to do is not increment the row, but the column for each....eg:

=SUM(Sheet2!E4,Sheet2!E16,Sheet2!E21,Sheet2!E25,Sheet2!E34,Sheet2!E60,Sheet2!E76,Sheet2!E79,Sheet2!E80,Sheet2!E89,Sheet2!E111)
=SUM(Sheet2!F4,Sheet2!F16,Sheet2!F21,Sheet2!F25,Sheet2!F34,Sheet2!F60,Sheet2!F76,Sheet2!F79,Sheet2!F80,Sheet2!F89,Sheet2!F111)
And so on,

Can anyone help?

Thanks

[Ace_XL]

Try

=SUMPRODUCT(--(ISNUMBER(MATCH(ROW(Sheet2!$D$1:$D$1000),{4,16,21,25,34,60,76,79,80,89,111},0))),INDEX(Sheet2!$D$1:$Z$1000,,ROW(A1)))

Copy down

[wheels8]

Thanks very much! Works perfectly!

[wheels8]

Forget that last comment....only works for 23 lines, then I get an 'Invalid Cell Reference Error'

[Ace_XL]

Try

=SUMPRODUCT(--(ISNUMBER(MATCH(ROW(Sheet2!$D$1:$D$1000),{4,16,21,25,34,60,76,79,80,89,111},0))),INDEX(Sheet2!$D$1:$IV$1000,,ROW(A1)))

[wheels8]

Thanks, tried looking for that but couldn't see it for the life of me! Much appreciated