Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to add a group of cells, using a sumif of another group of.
I want to add a group of cells, using a sumif of another group of cells.
Such as if A1,B1, D1 is equal to 3.5 add A2 to the sum of cells |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to add a group of cells, using a sumif of another group of.
Dim dblSum as Double
dblSum = application.Round(application.Sum(range("A1:B1,D1" )),1) if abs(dblSum-3.5) < .00000001 then dblSum = dblSum + Range("A2") End if -- Regards, Tom Ogilvy "larrylab" wrote in message ... I want to add a group of cells, using a sumif of another group of cells. Such as if A1,B1, D1 is equal to 3.5 add A2 to the sum of cells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match a group of cells with another group of cells | Excel Worksheet Functions | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |