Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For Each c In Range("A2", Range("A2").End(xlDown))
I would like vba to enter the result of the following array formula into column P in each row: {=SUM((A$2:A$1000=A2)*(F$2:F$1000=F2)*G$2:G$1000)} I would like to do this without actually entering the formula -- only the value. Any help would be appreciated. Thanks, Sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with excel array - select, add and calculate result | Excel Worksheet Functions | |||
Calculate time, but if less then hrs, end result must be 1 hrs | New Users to Excel | |||
Query on how I would calculate a result in Excel? | Excel Worksheet Functions | |||
find each of the items in an array and save result in another array | Excel Programming | |||
compare two columns, then calculate a result | Excel Discussion (Misc queries) |