At 10:59 03/10/2013 -0600, John Meyer wrote:
After looking over this problem a bit, I decided to scrap the sheet
name idea and just have all sales on one sheet.
sales are in this format:
DummyField, Date, DummyField, DummyField, SalesRep
For this table, I want to get the number of sales generated for a
particular agent by date.
Sales Rep 10/1/13 10/2/13 10/3/13
12345 ## ## ##
45678 ## ## ##
Would this lend itself to a DCOUNT solution (and to answer the
obvious question, I can't use a database at work).
I think I'd use SUMPRODUCT(). Suppopse your second table starts in
AA1. Then try something like:
=SUMPRODUCT($B$2:$B$999=AB$1;$E$2:$E$999=$AA2)
The individual parameters are logical expressions, and taking the
product of these ANDs them.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
