Formula Help Last One Please!!

Morrissey · Apr 9th, 2002, 02:13 PM

Ok I Want The Following Cells To Add Up

G18,G18,G19,G20,G21,G22,G23,G24,G25,G26,G27,G28 Then I Want Them To Be Multiplied By 0.2 And I Want That Result Added To Them

Eg

20
20
20
20
20+
---
100x0.2=20

100+20=120

that is the sort of result I want

Mark O'Brien · Apr 9th, 2002, 02:14 PM

You're taking the piss with this one aren't you?

Do you really want G18 summed twice or was that a typo?

Morrissey · Apr 9th, 2002, 02:15 PM

typo my bad sorry

Asala42 · Apr 9th, 2002, 02:17 PM

Morrissey,

Are you looking for just the following?

=1.2*sum(G18:G28)

Adam

Morrissey · Apr 9th, 2002, 02:18 PM

Thank Yopu Very Much I Love You

Moz

Mark O'Brien · Apr 9th, 2002, 02:19 PM

Hey, send some love my way man.

Morrissey · Apr 9th, 2002, 02:21 PM

I love you too

Jay Petrulis · Apr 9th, 2002, 02:22 PM

Hi,

I assume that you meant G17 as the first item, rather than G18.

The following routine assigns the value you want to the variable "sum_em_up."

----------
Sub add_em()
Dim sum_em_up As Double
Dim SumRng As Range

Set SumRng = Range("G17:G28")
sum_em_up = WorksheetFunction.Sum(SumRng) * 1.2
MsgBox sum_em_up

End Sub
----------------

Bye,
Jay

Morrissey · Apr 9th, 2002, 02:26 PM

Thanks Jay its done now!

Apr 9th, 2002, 02:14 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	You're taking the piss with this one aren't you? Do you really want G18 summed twice or was that a typo? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 9th, 2002, 02:19 PM	#6
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Hey, send some love my way man. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 02:13 PM	#1
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	Ok I Want The Following Cells To Add Up G18,G18,G19,G20,G21,G22,G23,G24,G25,G26,G27,G28 Then I Want Them To Be Multiplied By 0.2 And I Want That Result Added To Them Eg 20 20 20 20 20+ --- 100x0.2=20 100+20=120 that is the sort of result I want

Apr 9th, 2002, 02:15 PM	#3
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	typo my bad sorry

Apr 9th, 2002, 02:17 PM	#4
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Morrissey, Are you looking for just the following? =1.2*sum(G18:G28) Adam

Apr 9th, 2002, 02:18 PM	#5
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	Thank Yopu Very Much I Love You Moz

Apr 9th, 2002, 02:21 PM	#7
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	I love you too

Apr 9th, 2002, 02:22 PM	#8
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, I assume that you meant G17 as the first item, rather than G18. The following routine assigns the value you want to the variable "sum_em_up." ---------- Sub add_em() Dim sum_em_up As Double Dim SumRng As Range Set SumRng = Range("G17:G28") sum_em_up = WorksheetFunction.Sum(SumRng) * 1.2 MsgBox sum_em_up End Sub ---------------- Bye, Jay

Apr 9th, 2002, 02:26 PM	#9
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	Thanks Jay its done now!