Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum
=IF(A2:20=Checking - 5/3 Bank,SUM(B5:B15))
How would I make this work? -- FBN |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|