unable to solve array formula syntax

[Green Fox]

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")*(Fiscal="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

 

[Chip Pearson]

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

=SUM((DateAll)*(WeekdayAll="1")*(quarter="Q1")*(Fiscal="F2008"))
should bw
=SUM((DateAll)*(WeekdayAll=1)*(quarter="Q1")*(Fiscal="F2008"))

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

 

[Green Fox]

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