Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA syntax help: ReDim Preserve an array | Excel Discussion (Misc queries) | |||
Can I use an array function to solve my question??? | Excel Worksheet Functions | |||
Simplify syntax of a Sum(IF... Array | Excel Worksheet Functions | |||
syntax to refer to a range as an array? | Excel Worksheet Functions | |||
Want to Use an Array; Not Sure of Syntax | Excel Discussion (Misc queries) |