openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
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:
=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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message