P
PAL
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$282>0),('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.
=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$282>0),('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.