Looking for easy equation

  • Thread starter Thread starter alexzagrant
  • Start date Start date
A

alexzagrant

HI,
I am looking to simplify a HUGE equation. I have a large list (A- BP
columns) x 300 rows. And the equation is a simple add multiply
equation, but it is just so large i get an error before I finish it.

The general equation goes like this:

=$AC19*Qty!$AG$2+$AD19*Qty!$AE$2
+$BH19*Qty!$AG$2+$AF19*Qty!$AG$2
+$AG19*Qty!$AG$2........+$BP19*Qty!$AG$2

Maybe a function? or a If statement? maybe some kind of loop thing? I
don't have a clue.
Any help would be appreciated.
Thanks,
A.
 
try SUMPRODUCT
-----Original Message-----
how about lumping your ranges before multipling by ag2
=sum(ac19,bh19,etc)*ag2

--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
Back
Top