SUMIFS bringing VALUE error?

[nimv1]

Hi All, I have tried to apply the same logic given in a previous thread (now closed) but capturing the row details at top.
Please can you advise where I am going wrong, if that is ok? I must be really thick!
In cell D4 of sheet 1 tab (attached), I am trying to capture the total amount of each different currency?
Regards

[XLent]

Your calculation doesn't really make sense... i.e. seems you want to SUM relative Account Column (F:Y) rather than Total Column (Z)

=SUMIF(TB!$E:$E,$B3,TB!F:F)
copied across

if you think the header Account references may not align to the position on TB, e.g. Sheet1!D1 becomes Account 10 - then use INDEX

=SUMIF(TB!$E:$E,$B3,INDEX(TB!$A:$Z,0,MATCH(D$1,TB!$A$7:$Z$7,0))

[nimv1]

Thanks for quick reply and not just providing solution, but also where I went wrong. Much appreciated.