Do you mean ....?

=SUMIF(B4:B8,"BANK",J4:J8)

which sums columns J4:J8 if any of the corresponding B4:B8 = "BANK"

"Eclaires" wrote:

Please can anyone advise me why the following formula is not acceptable and
is coming up as "the formula you typed contains a error"?
The cell for the answer is formated as General

=SUMIF(B4:B8,"BANK",J4+J8)

Kind regards

Eclaires