sum
 

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

sum
 

Hi,
use

=sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B)


"FBN" wrote:

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

sum
 

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

sum
 

The Op has A2:20 for the first part and B5:B15 for the second. Sumproduct
would require both of those ranges to be the same size. That formula can not
work.
--
HTH...

Jim Thomlinson


"Eduardo" wrote:

Hi,
use

=sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B)


"FBN" wrote:

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

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

sum
 

sorry I missed something

sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B20)

"Eduardo" wrote:

Hi,
use

=sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B)


"FBN" wrote:

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

sum
 

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

sum
 

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