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 wrote: > =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).\$E\$1:\$E2000,A2) > > > On Mon, Sep 30, 2013 at 1:18 PM, John Meyer > 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 wrote: >> >>> < >>> ----- Original Message --(Start-looking-by-there) >>> From: John Meyer > >>> To: >>> 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 >>> > >>> >>> >> >