Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |