That does not answer the questions.
Question 1***
Is that A2 through A20? You have A2:20. <- No A in front of 20

Question 2***
What is Checking - 5/3 Bank? Is that text that you are looking for or is it
a calculation of some cells somewhere or???
--
HTH...

Jim Thomlinson


"FBN" wrote:

No, I am useing a spreadsheet with different banks and want a total for each
bank
--
FBN


"Jim Thomlinson" wrote:

Is that A2 through A20? You have A2:20. What is Checking - 5/3 Bank? If the
criteria is not met did you want the cell blank or ???
--
HTH...

Jim Thomlinson


"FBN" wrote:

=IF(A2:20=Checking - 5/3 Bank,SUM(B5:B15))
How would I make this work?
--
FBN