On Thursday, July 19, 2012 10:15:53 AM UTC-4, (unknown) wrote:
On Thursday, July 19, 2012 10:02:15 AM UTC-4, (unknown) wrote:
> On Thursday, July 19, 2012 9:56:29 AM UTC-4, Claus Busch wrote:
> > Hi,
> >
> > Am Thu, 19 Jul 2012 06:49:27 -0700 (PDT) schrieb :
> >
> > > I get "false" with this formula. When I hit CTRL+Shift+Enter it enters a "{" infront of the "=". Thoughts?
> >
> > that's correct. When you hit CTRL+Shift+Enter you have to get "{" in
> > front and "}" behind the formula. The formula is an array formula.
> > Paste the formula into your cell, press F2 and then CTRL+Shift+Enter
> >
> >
> > Regards
> > Claus Busch
> > --
> > Win XP PRof SP2 / Vista Ultimate SP2
> > Office 2003 SP2 /2007 Ultimate SP2
>
> Ok, got it to result a number now, however the # is 1. In what I have set up, it should be 25,000.



Do you think it has anything to do with the formula looking at the entire row, instead of it just looking at Column G where the data that counts is starting?




Yep, that was it. I changed it to G and now it is working properly. Thank you!