No, there are no gaps. I use the 1 row so the user can input the variables
to view the sales info for the weeks in question. I freeze the window pane
at cell E3.
The sort puts the customer name in the correct position but the sales
information is not correct so for example, the customer in number 1 position
should have $D3 but has $D27 which is the position it used to be before the
sort.
Thanks again,
Lee


"Khoshravan" wrote in message
...
Is there any gap (blank columns) between your table and sumproduct
columns?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Lee" wrote:

=SUMPRODUCT(--(CustomerNumberInvoice=Customers!$D3),--(WeekInvoice=$E$1),INVNET)
I am using the above to compare weekly customer sales of 2008 vs 2009. I
pull the info from a SQL server query for each salesperson's customer
info.
The Names are created using offset() and counta(). The problem occurs
when I
go to sort the data based on the formula's result it gives the customer's
name correct but the info is all wrong. What am I doing wrong?
Thanks for any help.

I want to say that the people in here have helped and taught me how to do
most of the above and thanks to all.
--
Lee Coleman