Okay, I've put up two screenshots.
the first contains the formula and what is listed in C1. The next is
the names of the individual sheets.
On 10/1/2013 8:21 AM, John Meyer wrote:
Same Err:501. I'll post up more in the office.
On 10/1/2013 8:11 AM, Johnny Rosenberg wrote:
2013/9/30 John Meyer <johnme...@pueblocomputing.com>
Still doesn't work. Back to the drawing board.
Exactly what does your current formula look like and what error
message do
you get? Still 501?
Johnny Rosenberg
On Mon, Sep 30, 2013 at 2:32 PM, John Meyer
<johnme...@pueblocomputing.com>wrote:
Derp, just saw that.
Thanks.
On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg <
gurus.knu...@gmail.com>wrote:
2013/9/30 John Meyer <johnme...@pueblocomputing.com>
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.
Hint 1:
Use the builtin help and search for 501. It will take you to the
error
codes. 501 means something like ”invalid character”. In this case it
seems
like you use ”,” instead of ”;” as parameter separators. I thought
that
there was a setting for that somewhere, but now I can't find it, so I
guess
that is a LibreOffice feature, but I'm not sure. I used
LibreOffice for
a
couple of years but I am back with Apache OpenOffice again, since
LibreOffice was way too unstable for me. It actually destroyed one
of my
spreadsheets but Apache OpenOffice fixed it for me, that's why I'm
back…
:D
Anyway, replace those commas with semi-colons and I think it will
work.
Hint 2:
If you are working with a big formula and it doesn't work, hit
Ctrl+F2
(select the cell that you are working with first) and you are able to
study
your formula a little better. For instance you can see sub values by
placing the cursor on different places in the formula. That way
it's a
little easier to find WHERE the error is.
Regards
Johnny Rosenberg
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
