----- Original Message ----- From: "Alberto Monteiro" <[EMAIL PROTECTED]> To: "Killer Bs Discussion" <[email protected]> Sent: Wednesday, July 13, 2005 5:16 PM Subject: Irregulars question: excel
> I have two columns - let's call them A and Z - and I want to calculate > what would in any decent programming language be the sum > of f(A[i], Z[i]) [where f is a given function]. Is there any way I can > do this? > > Alberto Monteiro Define AA[1]=f(A[1],Z[1]) go to the lower right corner, left click on it and drag it down to AA[n}, where n is the last row then, go to AAn+2, and say =sum(aa1:aan) and that's your answer. Dan M. _______________________________________________ http://www.mccmedia.com/mailman/listinfo/brin-l
