LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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)


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA syntax help: ReDim Preserve an array Dave Excel Discussion (Misc queries) 4 September 8th 07 07:37 PM
Can I use an array function to solve my question??? Oshtruck user Excel Worksheet Functions 1 August 10th 06 06:20 PM
Simplify syntax of a Sum(IF... Array JustMe602 Excel Worksheet Functions 4 October 7th 05 05:49 AM
syntax to refer to a range as an array? david cassain Excel Worksheet Functions 12 May 26th 05 11:28 PM
Want to Use an Array; Not Sure of Syntax RichK Excel Discussion (Misc queries) 4 May 6th 05 08:15 AM


All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"