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
|