Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional sum ?? | Excel Worksheet Functions | |||
Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
Is IF() Conditional the way to do this? | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional sum | Excel Worksheet Functions |