Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I add values of a column that are only in bold format?
Is there a way to add the values of a column, adding just the numbers that
are in bold format? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I add values of a column that are only in bold format?
Give this a try.
Sub SumTheBold() Dim Mud As Range Dim cell As Range Dim i As Integer Set Mud = Range("A1:A5") For Each cell In Mud If cell.Font.Bold = True Then i = cell.Value + i End If Next MsgBox i End Sub HTH Regards, Howard "Bytemylobster" wrote in message ... Is there a way to add the values of a column, adding just the numbers that are in bold format? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I add values of a column that are only in bold format?
Hi,
You would need a UDF for that. Alt+F11 to open Vb editor. Right click on 'This Workbook' and insert module and paste the code below in call with =sumbold(a1:a10) Function SumBold(Rng As Range) As Double Dim c As Range, TempSum As Double Application.Volatile TempSum = 0 On Error Resume Next For Each c In Rng.Cells If c.Font.Bold = True Then TempSum = TempSum + c.Value End If Next c On Error GoTo 0 Set c = Nothing SumBold = TempSum End Function Mike "Bytemylobster" wrote: Is there a way to add the values of a column, adding just the numbers that are in bold format? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I add values of a column that are only in bold format?
On Mon, 21 Sep 2009 12:13:56 -0700, "L. Howard Kittle"
wrote: Give this a try. Sub SumTheBold() Dim Mud As Range Dim cell As Range Dim i As Integer Set Mud = Range("A1:A5") For Each cell In Mud If cell.Font.Bold = True Then i = cell.Value + i End If Next MsgBox i End Sub HTH Regards, Howard "Bytemylobster" wrote in message ... Is there a way to add the values of a column, adding just the numbers that are in bold format? Get in mah Hard Drive! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bold format. | Excel Discussion (Misc queries) | |||
Format Help BOLD year in a specific vehicle application Column | Excel Worksheet Functions | |||
How do you sum just values that are bold in a list of values? | Excel Worksheet Functions | |||
How to bold daily max values | Excel Discussion (Misc queries) | |||
How can I sum only amounts that are in BOLD format within a column | New Users to Excel |