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