=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 >> > >> >> >
