unable to solve array formula syntax
 

I'm confounded by what I think should be a rather simple formula -- I
think an array formula. Here's what I have so far:

=SUM((DateAll)*(WeekdayAll="1")*(quarter="Q1")*(Fi scal="F2008"))
Date"All is a named range of numbers

WeekdayAll represent weekdays (1, 2, 3...7)

Quarter is either q1, q2, q3 or q4

Fiscal basically the fiscal year, in our case september through
august.

I want the sum of all the tuesday numbers from the first quarter in
fiscal 1997.


my data is in a simple list

Date Numbers weekday quarter Fiscal

Am I completely of base here, or am I working in the right direction?

Struggling,

Not yet throwing things.


Andy

unable to solve array formula syntax
 

Most likely, you don't want the quotes around the 1 in your comparison to
WeekdayAll.

=SUM((DateAll)*(WeekdayAll="1")*(quarter="Q1")*(Fi scal="F2008"))
should bw
=SUM((DateAll)*(WeekdayAll=1)*(quarter="Q1")*(Fisc al="F2008"))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Green Fox" wrote in message
ups.com...
I'm confounded by what I think should be a rather simple formula -- I
think an array formula. Here's what I have so far:

=SUM((DateAll)*(WeekdayAll="1")*(quarter="Q1")*(Fi scal="F2008"))
Date"All is a named range of numbers

WeekdayAll represent weekdays (1, 2, 3...7)

Quarter is either q1, q2, q3 or q4

Fiscal basically the fiscal year, in our case september through
august.

I want the sum of all the tuesday numbers from the first quarter in
fiscal 1997.


my data is in a simple list

Date Numbers weekday quarter Fiscal

Am I completely of base here, or am I working in the right direction?

Struggling,

Not yet throwing things.


Andy

unable to solve array formula syntax
 

Thanks Chip,

I had tried both with and without the quotation marks before without
success, your confirming the syntax I at least convinced me that my
error was elsewhere and to resolve it. I'm embarassed to say that I
had the formula right (without the quotation marks) but i was
referring to Fiscal 08 - the only fiscal I have that is void of
data.

abashedly grateful,
Andy

On Sep 5, 1:38 pm, "Chip Pearson" wrote:
Most likely, you don't want the quotes around the 1 in your comparison to
WeekdayAll.

=SUM((DateAll)*(WeekdayAll="1")*(quarter="Q1")*(Fi scal="F2008"))
should bw
=SUM((DateAll)*(WeekdayAll=1)*(quarter="Q1")*(Fisc al="F2008"))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consultingwww.cpearson.com
(email on the web site)