View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eclaires Eclaires is offline
external usenet poster
 
Posts: 10
Default MY FORMULA WON'T WORK.. WHY??

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