About Us

[email protected]

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:
> &gt; Hi,
> &gt;
> &gt; Am Thu, 19 Jul 2012 06:49:27 -0700 (PDT) schrieb :
> &gt;
> &gt; &amp;gt; I get &amp;quot;false&amp;quot; with this formula. When I hit CTRL+Shift+Enter it enters a &amp;quot;{&amp;quot; infront of the &amp;quot;=&amp;quot;. Thoughts?
> &gt;
> &gt; that&amp;#39;s correct. When you hit CTRL+Shift+Enter you have to get &amp;quot;{&amp;quot; in
> &gt; front and &amp;quot;}&amp;quot; behind the formula. The formula is an array formula.
> &gt; Paste the formula into your cell, press F2 and then CTRL+Shift+Enter
> &gt;
> &gt;
> &gt; Regards
> &gt; Claus Busch
> &gt; --
> &gt; Win XP PRof SP2 / Vista Ultimate SP2
> &gt; 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!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula assistance	Christmas May[_2_]	Excel Programming	1	November 25th 09 12:48 PM
Formula Assistance	A_Rookie	New Users to Excel	2	January 4th 08 04:50 PM
Formula assistance	Raisincain	Excel Discussion (Misc queries)	10	December 10th 07 07:20 PM
Assistance with Formula	Ben	Excel Worksheet Functions	3	June 15th 06 05:11 PM
Formula Assistance	Randy	Excel Worksheet Functions	6	April 5th 06 07:47 PM

Menu

About Us