Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array Formula, noncontigous range
Hello,
Application: Excel XP SP2 OS: WIN XP SP 1 Problem: Is it possible to use an array formula with an noncontigous range, or is it normal to get "#Value!" error? Example: Cells A1, A3, A5, A7 = Range named "Category" Cells B1, B3, B5, B7 = Range named "Data" Array Formula: ={SUM((Category="Test")*Data)} TIA, Werner |
#2
|
|||
|
|||
Don't think so as is, but you could try
=SUMPRODUCT(--(MOD(ROW(A1:A8),2)=1),--(A1:A8="Category"),B1:B8) -- HTH Bob Phillips "Werner Rohrmoser" wrote in message oups.com... Hello, Application: Excel XP SP2 OS: WIN XP SP 1 Problem: Is it possible to use an array formula with an noncontigous range, or is it normal to get "#Value!" error? Example: Cells A1, A3, A5, A7 = Range named "Category" Cells B1, B3, B5, B7 = Range named "Data" Array Formula: ={SUM((Category="Test")*Data)} TIA, Werner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
What instead of an array formula? | Excel Discussion (Misc queries) |