Conditional
PAL,
I should have noted that in Array formulas, Multiplication is the equivalent of logical AND,
Addition (within parens) is the equivalent of logical OR.
HTH,
Bernie
MS Excel MVP
"PAL" wrote in message
...
I am working on a big array formula that currently works great.
=AVERAGE(IF(('Export and Site View'!$M$2:$M$282=$K$4)*('Export and Site
View'!$C$2:$C$282=$A$2)*('Export and Site
View'!$H$2:$H$282="Active")*('Export and Site View'!$N$2:$N$2820),('Export
and Site View'!$N$2:$N$282),""))
The first condition = $K$4 references a field with a year (ie. 2007). How
can I change the condition to reference 2006 and 2007. I am looking to return
a values that look up two years. Do I have to add an OR Condition? If so
where?
Thanks.
|