Calculation

[alen_re]

Hi !

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

I have a formula:

=SUMPRODUCT(--(Selling!F5:F30000="Laser printers
mono");--(Selling!A5:A30000>=--F1);--(Selling!A5:A30000<=--F2))

so this formula calculates for me in how many cells I have "Laser
printers mono" 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 "Laser printers mono"..
The formula I've got now only calculates in how many cells I have the
word "Laser printers mono", now I want it to calculate numbers in the
cells I've added.. and show it..

Thanks a lot.. I hope you understand me

 

[daddylonglegs]

Try this

=SUMPRODUCT((Selling!F5:F30000="Laser printer
mono")*(Selling!A5:A30000>=--F1)*(Selling!A5:A30000<=--F2)*Selling!H5:L30000

 

[Guest]

Sub RSQ()
Dim Rng As Variant
Rng = Selection
Range("G10").FormulaArray = "= RSQ(" & Selection.Address & ",ROW(" &
Selection.Address & "))": _
Range("G10") = Range("G10").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

 

[Guest]

Sorry, this was posted to the wrong thread.

Jerry

 

[alen_re]

Thanks a LOT... I tried this and it actually worked for me..
I cant thank you enough