Date Incorporation Frustration (sorry for the re-post)
You cannot do that as the embedded average will return a single value which
will throw SP as it wants a same size array.
What are you trying to do exactly, get an average instead of a sum? If so,
maybe this array formula
=AVERAGE(IF(
('Raw Data'!$A$4:$A$5000=--"2009,-07-01")
*('Raw Data'!$A$4:$A$5000<=--"2009-09-30")
*('Raw Data'!$H$4:$H$5000="Barb B"),'Raw Data'!$C$4:$C$5000))
--
__________________________________
HTH
Bob
"Danny Boy" wrote in message
...
Just for clarification, here is an example of where I was able to
incorporate
"date parameters" and the formula worked just as I wanted it to. And yes I
am
using Cell A4 to reflect the date, and I am using Excel 2007. The formula
below works perfectly:
=SUMPRODUCT(('Raw Data'!$A$4:$A$5000=DATE(2009,7,1))*('Raw
Data'!$A$4:$A$5000<=DATE(2009,9,30)*(('Raw Data'!$H$4:$H$5000="Barb
B")*(('Raw Data'!$D$4:$D$5000="LATE")))))
However, when I tried to do the exact same thing in my other two formulas
(see example below), I kept getting error messages:
=SUMPRODUCT(('Raw Data'!$A$4:$A$5000=DATE(2009,7,1))*('Raw
Data'!$A$4:$A$5000<=DATE(2009,9,30)*('Raw Data'!$H$4:$H$5000,"Barb
B"),AVERAGE(IF('Raw Data'!$H$4:$H$5000="Barb B",'Raw
Data'!$C$4:$C$5000)),"")
=SUMPRODUCT(('Raw Data'!$A$4:$A$5000=DATE(2009,7,1))*('Raw
Data'!$A$4:$A$5000<=DATE(2009,9,30)*('Raw
Data'!$F$4:$F$5000,"OP"),AVERAGE(IF('Raw Data'!$F$4:$F$5000="OP",'Raw
Data'!$C$4:$C$5000)),"")
Again thank you for any help.....So far the suggestions don't seem to be
generating outcomes without errors.
Dan
|