Using =SUM...just can't figure this simple thing out...
Hi,
Am Wed, 19 Mar 2014 15:25:26 +0000 schrieb Naxzor:
I'm trying to add the cells (J6:J8,J10,J15:J25) together, and then that
total needs to be multiplied by (B29/100 and then add 1). Then when
that's all done, add the cells J11:J13,J26 to the total.
try:
=SUM(J6:J8,J10,J15:J20)*(B29/100+1)+SUM(J11:J13,J26)
Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional
|