SUMIFS bringing VALUE error?

Hi there,
I was hoping someone can help?
Been struggling to see what I have done wrong with my SUMIF formula?
C4 cell should sum values of all accounts starting with 100 and has name account 1.
If this works, I would like to drag down and do for all accounts if possible.
I have attached a sample with the formula which is bringing the error. Spent quite some time but cannot see where the formula is wrong.
Hope you can help?
Regards
Nim

How about, in C4 copied down & across
=SUMIFS(INDEX(TB!$C:$V,,MATCH(C$1,TB!$C$1:$V$1,0)),TB!$A:$A,$A4)

Both,
Thankyou so much for coming back to me so quickly. I tried the first, which worked. I am sure the second Index does as well and will try that as well.
You have made my day, thankyou both for making my wknd.

You're welcome & thanks for the feedback