Array Formula, noncontigous range

  • Thread starter Thread starter Werner Rohrmoser
  • Start date Start date
W

Werner Rohrmoser

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
 
Don't think so as is, but you could try

=SUMPRODUCT(--(MOD(ROW(A1:A8),2)=1),--(A1:A8="Category"),B1:B8)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array formula: how to join 2 ranges together to form one array? 2
Array formulas/selecting data 2
Sumif with named range of nonadjacent cells. 6
If...rows and columns 3
SUMIF data that falls within a range 3
Comparison of columns using Conditional Formatting 3
sort and sum data range with some blank cells 1
Counting Days of Week in Date Ranges 1

Back
Top