Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF in VBA
I see what I missed Thanks for the help. Next question. I there a way to use range names? Sub summer() Dim EnderA As Range Dim EnderC As Range Dim EnderD As Range Dim Acta As String Range("A7").Select Set EnderA = Range(Selection, Selection.End(xlDown)) Set EnderC = Range(Selection, Selection.End(xlDown)) Set EnderD = Range(Selection, Selection.End(xlDown)) Range("E7:E1422").Formula = _ "=IF(A7=A6,"""",SUMIF(EnderA,A7,EnderC)" "-SUMIF(EnderA,A7,EnderD)) -- LeeBoWad ----------------------------------------------------------------------- LeeBoWadd's Profile: http://www.excelforum.com/member.php...fo&userid=1655 View this thread: http://www.excelforum.com/showthread.php?threadid=31409 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
SUMIF help! | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |