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