Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am not familiar with the SUMPRODUCT function. I asked someone to do some
work for me on a spreadsheet and he added the following expression to a cell: =SUMPRODUCT(--('PO Log'!$AB$2:$AB$1203='Summary by Line Equivalent'!A2),('PO Log'!$I$2:$I$1203),--('PO Log'!$AA$2:$AA$1203<"CANCELLED"),--(PO Log'!$X$2:$X$1203<"")) I've been trying to understand exactly what this is doing, and I can't seem to find anything that helps me understand what the "--" is for. Can someone put this expression into English for me ? Thanks ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
another sumproduct question | Excel Worksheet Functions | |||
another sumproduct question | Excel Worksheet Functions | |||
SUMPRODUCT Question... | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) |