Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to Excel VB
Is there a way to code the following formula idea to pull from an Excel VB array? {=SUM((Market="USA")*(Customer_Name="ExcelTip"))} I have an array with multiple report names and multiple dates I nee to be able to tell how many times a given report appeared on a give date. A date may have (multiple reports or the same report multiple times and a report many have multiple dates. Any help would be greatly appreciated -- JAV ----------------------------------------------------------------------- JAVB's Profile: http://www.excelforum.com/member.php...fo&userid=2930 View this thread: http://www.excelforum.com/showthread.php?threadid=55743 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to Excel VB
Maybe
Sub test() Dim lngResult As Long lngResult = CLng(Evaluate("=SUMPRODUCT(--(" & _ Range("Market").Address(True, True, xlA1, True) & _ "=""USA""), --(" & _ Range("Customer_Name").Address(True, True, xlA1, True) & _ "=""ExcelTip""))")) MsgBox lngResult End Sub "JAVB" wrote: Is there a way to code the following formula idea to pull from an Excell VB array? {=SUM((Market="USA")*(Customer_Name="ExcelTip"))} I have an array with multiple report names and multiple dates I need to be able to tell how many times a given report appeared on a given date. A date may have (multiple reports or the same report multiple times) and a report many have multiple dates. Any help would be greatly appreciated. -- JAVB ------------------------------------------------------------------------ JAVB's Profile: http://www.excelforum.com/member.php...o&userid=29304 View this thread: http://www.excelforum.com/showthread...hreadid=557434 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |