View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Caro-Kann Defence[_2_] Caro-Kann Defence[_2_] is offline
external usenet poster
 
Posts: 12
Default 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