Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving space in Array formula Sum(If(())...
Hi.
I am usually pretty successful using the array formula Sum(IF(( but I am having difficulty entering multiple criteria using the same range. I check KB article 275165 and found if I copied the example in the article to a worksheet it worked okay. However, when I apply it to my workbook, I keep getting the N/A error result. I am working with account balances by month and have a worksheet defined as follows: Month1 Month2 Month3 Month4 ..... Month12 Acct1 Acct2 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving space in Array formula Sum(If(())...
Sorry! Forget this one!
"Caro-Kann Defence" wrote: Hi. I am usually pretty successful using the array formula Sum(IF(( but I am having difficulty entering multiple criteria using the same range. I check KB article 275165 and found if I copied the example in the article to a worksheet it worked okay. However, when I apply it to my workbook, I keep getting the N/A error result. I am working with account balances by month and have a worksheet defined as follows: Month1 Month2 Month3 Month4 ..... Month12 Acct1 Acct2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving space in Array formula Sum(If(())...
Hi,
Can you be a little more specific, like the criteria you are trying to test for in the Ifs? You might also show what you have tried? And some examples of the data might help too. Thanks, "Caro-Kann Defence" wrote: Hi. I am usually pretty successful using the array formula Sum(IF(( but I am having difficulty entering multiple criteria using the same range. I check KB article 275165 and found if I copied the example in the article to a worksheet it worked okay. However, when I apply it to my workbook, I keep getting the N/A error result. I am working with account balances by month and have a worksheet defined as follows: Month1 Month2 Month3 Month4 ..... Month12 Acct1 Acct2 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving space in Array formula Sum(If(())...
Sorry about that. I thought I had accidentally completed this and re-did the
message. Here it is on another post: Hi. I am usually pretty successful using the SUM(IF(( array formula but am having difficult when trying to use the { } with multiple criteria for one range in the formula. I have looked at KB article 275165 but haven't found this very helpful as I keep getting the N/A error. My worksheet is as follows: colums rows Month1 Month2 Month3 .... Month12 Acct1 Amt11 Amt21 ... Amt121 Acct2 Amt12 Amt22 .... ... ... ... AcctN Amt1N Amt2N ... Amt12N I need to sum over the account range (Acct1 - AcctN) for one month (Month x). My formula is SUM(IF((MonthRange=Monthx)*(AcctRange={Accta,Acctb }),Amt11:Amt12N,0)) It works so long as I have only Accta or Acctb (or if I connect several criteria with AcctRange). I'd like it to know if there is a way to get it to work in accordance with KB article 275165. P.S. The accounts listed in the rows are number types (but I have tried it while using strings as well). What am I missing?!?!?!?!!? Thanks! "David" wrote: Hi, Can you be a little more specific, like the criteria you are trying to test for in the Ifs? You might also show what you have tried? And some examples of the data might help too. Thanks, "Caro-Kann Defence" wrote: Hi. I am usually pretty successful using the array formula Sum(IF(( but I am having difficulty entering multiple criteria using the same range. I check KB article 275165 and found if I copied the example in the article to a worksheet it worked okay. However, when I apply it to my workbook, I keep getting the N/A error result. I am working with account balances by month and have a worksheet defined as follows: Month1 Month2 Month3 Month4 ..... Month12 Acct1 Acct2 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving space in Array formula Sum(If(())...
See possible answer at your other posting of this question.
-- Regards, Tom Ogilvy "Caro-Kann Defence" wrote in message ... Sorry about that. I thought I had accidentally completed this and re-did the message. Here it is on another post: Hi. I am usually pretty successful using the SUM(IF(( array formula but am having difficult when trying to use the { } with multiple criteria for one range in the formula. I have looked at KB article 275165 but haven't found this very helpful as I keep getting the N/A error. My worksheet is as follows: colums rows Month1 Month2 Month3 .... Month12 Acct1 Amt11 Amt21 ... Amt121 Acct2 Amt12 Amt22 ... ... ... ... AcctN Amt1N Amt2N ... Amt12N I need to sum over the account range (Acct1 - AcctN) for one month (Month x). My formula is SUM(IF((MonthRange=Monthx)*(AcctRange={Accta,Acctb }),Amt11:Amt12N,0)) It works so long as I have only Accta or Acctb (or if I connect several criteria with AcctRange). I'd like it to know if there is a way to get it to work in accordance with KB article 275165. P.S. The accounts listed in the rows are number types (but I have tried it while using strings as well). What am I missing?!?!?!?!!? Thanks! "David" wrote: Hi, Can you be a little more specific, like the criteria you are trying to test for in the Ifs? You might also show what you have tried? And some examples of the data might help too. Thanks, "Caro-Kann Defence" wrote: Hi. I am usually pretty successful using the array formula Sum(IF(( but I am having difficulty entering multiple criteria using the same range. I check KB article 275165 and found if I copied the example in the article to a worksheet it worked okay. However, when I apply it to my workbook, I keep getting the N/A error result. I am working with account balances by month and have a worksheet defined as follows: Month1 Month2 Month3 Month4 ..... Month12 Acct1 Acct2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to add space within text | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
Saving an array | Excel Programming | |||
search formula for 1st space | Excel Programming |