Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif in vba
Hi Im trying to use =(SUMIF(teams,Home,power)) with vba. teams,home
and power are named ranges. The calc works perfect in excel. Ive tried Dim xt As Double xt = Application.WorksheetFunction.SumIf(Range("teams") , Range ("Home"), Range("Power")) MsgBox xt. The reason I want to do this is, in excel the calc is dependent on other data, and when calculated I dont want the value to change, but because its calc from other data which changes daily the value changes to, so I thought Id calc using vba and write the value to appropiate range then when values change this result wont. Basically its the previous days result. Thanks Regards Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=SUMIF | Excel Discussion (Misc queries) | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | 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 |