openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Meyer <johnme...@pueblocomputing.com>
Subject Re: VLOOKUP vs Macros
Date Mon, 30 Sep 2013 19:22:12 GMT
=COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)


On Mon, Sep 30, 2013 at 1:18 PM, John Meyer
<johnmeyer@pueblocomputing.com>wrote:

> So I guess I'm doing something wrong here.
>
> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>
> Returns an Err:501.
>
>
>
> On Sun, Sep 29, 2013 at 10:59 PM, Coreurus <coreurus@aol.com> wrote:
>
>> <
>> ----- Original Message --(Start-looking-by-there)
>> From: John Meyer >
>> To: <users@openoffice.apache.org>
>> Sent: Saturday, 28 September, 2013 04:40 PM
>> Subject: Re: VLOOKUP vs Macros
>>
>>
>> > I sent that a little too soon.
>> >
>> > The title refers to the fact that I was looking into another solution.
>> >
>> > the sales sheet for each day is broken down with the following
>> information:
>> >
>> >
>> > Date, EmpID
>> >
>> >
>> >
>> > Currently, what I am doing is separating them by date.  However, I was
>> > thinking a much less cluttered solution would involve pulling the date
>> > from the bonus calculation field and then doing either a VLOOKUP with a
>> > count or Macro.  Where would I start looking if I wanted to do either
>> > one of those solutions?
>> > Back to searching for the answer.
>> >
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> > For additional commands, e-mail: users-help@openoffice.apache.org
>> >
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message