F
FBN
=IF(A2:20=Checking - 5/3 Bank,SUM(B5:B15))
How would I make this work?
How would I make this work?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eduardo
Hi,
use
=sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B)
use
=sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B)
J
Jim Thomlinson
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 ???
criteria is not met did you want the cell blank or ???
J
Jim Thomlinson
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.
would require both of those ranges to be the same size. That formula can not
work.
D
David Biddulph
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.
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.
E
Eduardo
sorry I missed something
sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B20)
sumproduct(--(A2:A20="Checking - 5/3 Bank"),B2:B20)
F
FBN
No, I am useing a spreadsheet with different banks and want a total for each
bank
bank
J
Jim Thomlinson
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???
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???