Re: Limitations in array formulas ?

On 9/12/08 9:33 AM, in article 59b5952a.-1@xxxxxxxxxxxxxxxxxxxxxxx,
"nunoferreira@xxxxxxxxxxxxxxxx" <nunoferreira@xxxxxxxxxxxxxxxx> wrote:

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Two kinds of problems I noticed:

1.The following formula does not produce the expected results:

{=SUM(IF(AND(WEEKDAY($G$26:$G$29)=3,MONTH($G$26:$G$29)=12),$H$26:$H$29,0))}

(The formula tries to sum up the values corresponding to Tuesdays of December)

2. The following formula cannot even be entered in Excel:

{=SUM(IF(2+2=3,$H$26:$H$29,0))}

(The formula has no sense; it is just to highlight that the parser does not
recognise the first argument of the IF (2+2=3) as a logical test)

Someone has a workaround (or at least an explanation?). Thanks very much
You'll have to provide some more info. The formula in 1. Is fine. What does
the data look like? What results does it produce? What do you think it
should produce?

The formula in 2 is also fine. I agree it makes no sense, but the syntax is
correct and it is parsed fine, and correctly produces the result of 0. You
are doing something wrong, or misunderstanding something. What happens when
you enter the formula?

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

.