| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel expression "sumproduct" in Access
Hi all,
I'm now building an Access databse and analysis market report. Does anyone know that how to realize the Excel expression "sumproduct" in Access? Sumproduct: Multiplies corresponding components in the given arrays and returns the sum of those products. SUMPRODUCT(array1,array2,array3, ...) It returns similiar result as the formula SUM(A2:B4*C2:D4) entered a an array. Thanks in advance!! :) Best Regards, F -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ACCESS ="NO" BUT EXCEL DISPLAYS "0" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
| "Cannot access read-only document" (I get this error when I try to open an Excel file) | Setting up and Configuration of Excel | |||
| "Programmatic Access to be Denied" displays when running macro on excel in XP | Excel Programming | |||
Linear Mode
