I assume that you are looking to see in "bank" appears in B1:B8 and if it
does add J4 & J8. If correct try:-

=IF(COUNTIF(B4:B8,"=bank"),J4+J8,"Not defined")

"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