MY FORMULA WON'T WORK.. WHY??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Do you mean ....?

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

which sums columns J4:J8 if any of the corresponding B4:B8 = "BANK"
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
Why doesn't this work ? 2
Formula not working 4
Peculiar default cell format 1
How to Control a formula by a character in adjacent column on same 4
Formula works on all but one worksheet 2
insert new row and copy formula 1
Sumproduct 3

Back
Top