sum
What are you trying to test? A2:A20 is a range of cells. Is "Checking -
5/3 Bank" a text string or are Checking and Bank two defined names, and are
you looking for the value of Checking - 5/3 * Bank? If the latter, are you
looking for the sum, or average, or minimum, or maxium, value in A2:A20 to
be equal to that, or did you intend this to be an array formula with results
in a range of 19 cells?
Define your question, and then we may be able to help you.
--
David Biddulph
"FBN" wrote in message
...
=IF(A2:20=Checking - 5/3 Bank,SUM(B5:B15))
How would I make this work?
--
FBN
|