So what I want isn't complicated to explain, but apparently difficult to achieve.

I have a spreadsheet with several pages. On one is the main orders page, each has an email address listed. Next I have a page that lists giveaways by email. Lastly I have a customer page, again with emails.

Now, on the customer page, I'd like to show total number of orders based on criteria. DSUM works great if I want to do one field for this... but I want to populate this same field for 3,000+ customers without having to make 3,000 criteria table arrays because of the email address!

Currently I have it verify PAYSTATUS as well as CITY for the DSUM because I do list it by city, but I want to have the criteria search their email address. Is there any way to put a reference in the criteria table to reference current cell's(where the function is) first column? Like =A[ROW].

Any help would be appreciated.

** I've done Sum with nested if statements, and that works until I put this spreadsheet up on Google docs for others to access it... then that fails. So I'm looking for other solutions.

Thanks again.