Sorry, that e-mail got sent off too quickly. I'm trying this formula
=COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
C1 contains the name of the worksheet ("09-27-13") and I'm trying to use
it. However, it keeps giving me an err:501.
On Mon, Sep 30, 2013 at 1:22 PM, John Meyer
<johnme...@pueblocomputing.com>wrote:
> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>
>
> On Mon, Sep 30, 2013 at 1:18 PM, John Meyer <johnme...@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 <coreu...@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-unsubscr...@openoffice.apache.org
>>> > For additional commands, e-mail: users-h...@openoffice.apache.org
>>> >
>>>
>>>
>>
>
