Referring to Names

[Timmy Mac1]

Hi Frank

I'm looking for something that's easy to copy across.

Say column A contains an alpha and columns B to X contain variou
numerical values with range created names of Bdata to Xdata.

I'm wondering if there is any way of writing the formul
Sumif(Alpha,A,Bdata) by referring Bdata to a cell reference instead o
using the term "Bdata" itself, so that I can change the cell and brin
up the relevant result.

Hope this makes sense

Timmy Ma

 

[Frank Kabel]

Hi
try
=SUMIF(A1:A100,"A",OFFSET(A1:A100,MATCH("Bdata",A1:X1,0)))