Array formulas

  • Thread starter Thread starter Bankboy
  • Start date Start date
B

Bankboy

Is it possible to use wildcards in array formulas. I have a large amoun
of data in a worksheet, columns A to K with aproximately 1500 rows
Within the rows and columns are certains product models and eac
distributor can be allocated a number of models. I want to be able t
use wildcards to pick up all types of model per distributor.

eg

The distributor is 1agris. He has orders for 30 products, 20 of whic
are the same model group but differently named such as GD64g, GD84g
GD85g etc. He also has other models on order.

I want to be able to list all the distributors in column a, the mode
ranges in columns b to h and from an imported text file into
differnet worksheet, automatically total the various models in th
various columns and rows per distributor.

I tried using the following but it doesn't seem to work.


{=SUM(IF(Text!$A$2:$A$1500=$A6,IF(Text!$D$2:$D$1500="GD*",1,0),0))}

were $a6 =iagris and column d contains all the different mode
descriptions
 
Hi
try
=SUMPRODUCT(--(Text!$A$2:$A$1500=$A6),--ISNUMBER(FIND("GD",Text!$D$2:$D
$1500)))
 
Back
Top