Arrays - Constants and Variables together

K

kraljb

I am building a flash report that is based off of a large table o
information. The information is stored as such:
ProductNumber,QtySold,Sales$,SiteNumber

Now I have all the product numbers listed on the report sheet goin
down such that I want to be able to put the SiteNumber in cell A2 an
have the report pulling in that sites information for each produc
(even if there is none sold). And if no site is there than to take th
total of everyones information.

The report is ProductNum,QtySld,Sales$$. The ProductNumber will be
static number corresponding with the item.

The formula I am currently using is as follows:

=IF($A$2="",SUMIF(ProductNumber,$C3,QtySold),DSUM(SalesInfo,QtySold,xxxxxx))

The xxxxxx is where I am running into problems. What I would like it t
be is ($A$1:$A$2, {"ProductNumber",$C3}) but because I need the array
to be seperate and include one constant even though the rest is base
off of information in cells.

I have not worked largly with arrays and am unsure if there is anywa
to have a constant and a variable.

Thank you in advance,
John Kra
 
Top