I'm using the following 'SUMIFS' where column H is formatted as text and contains 021 and 21. However the function is unable to distinguish between the two.

=SUMIFS('Trial Balances'!$G:$G,'Trial Balances'!$H:$H,'Consol by company'!E$1,'Trial Balances'!$J:$J,'Consol by company'!$A21)

I'd be grateful if someone could come up with a solution to this.

Many thanks

Wilf