CODEWITHSUNDEEP
excel-formula
Philipp Mochine
Philipp Mochine

Reputation: 4705

How to sum a function in excel?

I want to sum this function up:

=I3*(A3*0.014+0.25)+I4*(A4*0.014+0.25)+I5*(A5*0.014+0.25)+....

But I don't know which function to use to sum everything to one. That doesn't work unfortunately

=SUM(I3:I9)*(SUM(A3:A9)*0.014+0.25)

Upvotes: 1

Views: 35

Answers (1)

Scott Craner
Scott Craner

Reputation: 152525

Use SUMPRODUCT:

=SUMPRODUCT(I3:I9 * (A3:A9 * 0.014 + 0.25))

Upvotes: 2

Related Questions