Sum of Highlighted values
in [Functions]
|
Prev: Insert Paste
Next: Help on combining two IF statements
From: Khusro on 24 Jan 2010 08:00 Is there any way I can perform calculation on the basis of cell formatting such as get the sum of highlighted cells
From: Niek Otten on 24 Jan 2010 08:19 http://xldynamic.com/source/xld.ColourCounter.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Khusro" <Khusro(a)discussions.microsoft.com> wrote in message news:59453745-6168-4C97-B265-7A6EC7DF1DA1(a)microsoft.com... > Is there any way I can perform calculation on the basis of cell formatting > such as get the sum of highlighted cells >
From: Mike H on 24 Jan 2010 08:21 How are the cells highlighted, is it conditional formatting or a fill colour? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Khusro" wrote: > Is there any way I can perform calculation on the basis of cell formatting > such as get the sum of highlighted cells >
From: Don Guillett on 24 Jan 2010 11:39 Sub sumselection()'non-contiguous assign to button or shape MsgBox Application.Sum(Selection) End Sub 'below ONLY if a contiguous selection. Private Sub Worksheet_SelectionChange(ByVal Target As Range) MsgBox Application.Sum(Selection) End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Khusro" <Khusro(a)discussions.microsoft.com> wrote in message news:59453745-6168-4C97-B265-7A6EC7DF1DA1(a)microsoft.com... > Is there any way I can perform calculation on the basis of cell formatting > such as get the sum of highlighted cells >
From: Don Guillett on 24 Jan 2010 13:41
I probably misread the post but this may still be useful -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Don Guillett" <dguillett1(a)gmail.com> wrote in message news:u2zafPRnKHA.5524(a)TK2MSFTNGP05.phx.gbl... > Sub sumselection()'non-contiguous assign to button or shape > MsgBox Application.Sum(Selection) > End Sub > > 'below ONLY if a contiguous selection. > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > MsgBox Application.Sum(Selection) > End Sub > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "Khusro" <Khusro(a)discussions.microsoft.com> wrote in message > news:59453745-6168-4C97-B265-7A6EC7DF1DA1(a)microsoft.com... >> Is there any way I can perform calculation on the basis of cell >> formatting >> such as get the sum of highlighted cells >> > |