| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting #Value error on Sumproduct with non-contiguous cells
I'm trying sumproduct, where one of the arrays is non-contiguous:
SUMPRODUCT(($AB$607:$AB$615=TRUE)*(AY583,BD583,BE5 83,BF583,BG583,BH583,BK583,BL583,BM583)) The result in receiving a #Value error. Any suggestions or workarounds. Thanks...AJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-contiguous range and Sumproduct to average | Excel Worksheet Functions | |||
| Error Message - Input Range must be a contiguous Reference Help!!! | Excel Discussion (Misc queries) | |||
| Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column | Excel Programming | |||
| Error 1004 using not contiguous data | Charts and Charting in Excel | |||
| how can i use SUMPRODUCT with a non-contiguous set of cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
