openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <>
Subject Re: Indirect and Address problem (from VLOOKUP and Macros)
Date Thu, 03 Oct 2013 17:42:58 GMT
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:

The individual parameters are logical expressions, and taking the 
product of these ANDs them.

I trust this helps.

Brian Barker

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message