software

Hi !

I have a problem, I can't figure this out

I have a formula:

=SUMPRODUCT(--(Selling!F5:F30000=quot;Laser printers
monoquot;);--(Selling!A5:A30000gt;=--F1);--(Selling!A5:A30000lt;=--F2))

so this formula calculates for me in how many cells I have quot;Laser
printers monoquot; and F1 and F2 are dates, like a criteria..
Now I want my formula to calculate also cells H, I, J, K, L.. in these
cells are numbers of sold quot;Laser printers monoquot;..
The formula I've got now only calculates in how many cells I have the
word quot;Laser printers monoquot;, now I want it to calculate numbers in the
cells I've added.. and show it..

Thanks a lot.. I hope you understand me --
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=506296
Try this

=SUMPRODUCT((Selling!F5:F30000=quot;Laser printers
monoquot;)*(Selling!A5:A30000gt;=--F1)*(Selling!A5:A30000lt;=--F2)*Selling!H5:L30000)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=506296Sub RSQ()
Dim Rng As Variant
Rng = Selection
Range(quot;G10quot;).FormulaArray = quot;= RSQ(quot; amp; Selection.Address amp; quot;,ROW(quot; amp;
Selection.Address amp; quot;))quot;: _
Range(quot;G10quot;) = Range(quot;G10quot;).Value
' I want to replace C2:C11 with Rng in the line above
End Sub

However, in Excel versions prior to 2003, CORREL()^2 is numerically better
than RSQ()

Jerry

quot;alen_requot; wrote:

gt;
gt; Hi !
gt;
gt; I have a problem, I can't figure this out
gt;
gt; I have a formula:
gt;
gt; =SUMPRODUCT(--(Selling!F5:F30000=quot;Laser printers
gt; monoquot;);--(Selling!A5:A30000gt;=--F1);--(Selling!A5:A30000lt;=--F2))
gt;
gt; so this formula calculates for me in how many cells I have quot;Laser
gt; printers monoquot; and F1 and F2 are dates, like a criteria..
gt; Now I want my formula to calculate also cells H, I, J, K, L.. in these
gt; cells are numbers of sold quot;Laser printers monoquot;..
gt; The formula I've got now only calculates in how many cells I have the
gt; word quot;Laser printers monoquot;, now I want it to calculate numbers in the
gt; cells I've added.. and show it..
gt;
gt; Thanks a lot.. I hope you understand me
gt;
gt;
gt; --
gt; alen_re
gt; ------------------------------------------------------------------------
gt; alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
gt; View this thread: www.excelforum.com/showthread...hreadid=506296
gt;
gt;

Sorry, this was posted to the wrong thread.

Jerry

quot;Jerry W. Lewisquot; wrote:

gt; Sub RSQ()
gt; Dim Rng As Variant
gt; Rng = Selection
gt; Range(quot;G10quot;).FormulaArray = quot;= RSQ(quot; amp; Selection.Address amp; quot;,ROW(quot; amp;
gt; Selection.Address amp; quot;))quot;: _
gt; Range(quot;G10quot;) = Range(quot;G10quot;).Value
gt; ' I want to replace C2:C11 with Rng in the line above
gt; End Sub
gt;
gt; However, in Excel versions prior to 2003, CORREL()^2 is numerically better
gt; than RSQ()
gt;
gt; Jerry
gt;
gt; quot;alen_requot; wrote:
gt;
gt; gt;
gt; gt; Hi !
gt; gt;
gt; gt; I have a problem, I can't figure this out
gt; gt;
gt; gt; I have a formula:
gt; gt;
gt; gt; =SUMPRODUCT(--(Selling!F5:F30000=quot;Laser printers
gt; gt; monoquot;);--(Selling!A5:A30000gt;=--F1);--(Selling!A5:A30000lt;=--F2))
gt; gt;
gt; gt; so this formula calculates for me in how many cells I have quot;Laser
gt; gt; printers monoquot; and F1 and F2 are dates, like a criteria..
gt; gt; Now I want my formula to calculate also cells H, I, J, K, L.. in these
gt; gt; cells are numbers of sold quot;Laser printers monoquot;..
gt; gt; The formula I've got now only calculates in how many cells I have the
gt; gt; word quot;Laser printers monoquot;, now I want it to calculate numbers in the
gt; gt; cells I've added.. and show it..
gt; gt;
gt; gt; Thanks a lot.. I hope you understand me
gt; gt;
gt; gt;
gt; gt; --
gt; gt; alen_re
gt; gt; ------------------------------------------------------------------------
gt; gt; alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=506296
gt; gt;
gt; gt;


Thanks a LOT... I tried this and it actually worked for me..
I cant thank you enough
daddylonglegs Wrote:
gt; Try this
gt;
gt; =SUMPRODUCT((Selling!F5:F30000=quot;Laser printers
gt; monoquot;)*(Selling!A5:A30000gt;=--F1)*(Selling!A5:A30000lt;=--F2)*Selling!H5:L30000)--
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=506296