| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SumProduct with more than 1 selection
Hi all,
I am using the following formular which works fine. The Z... are named ranges of columns. =SUMPRODUCT(--(Zmth="APR"),--(Zbuscode=18),--(Zinvest="A"),Zamt) But If I want to select a number of additional selections to Zinvest in the same column e.g. A, B, C I seem to be getting a problem. Tried this which resulted in Zero. =SUMPRODUCT(--(Zmth=B2),--(Zbuscode=18),--(Zinvest="A"),--(Zinvest="B"),--(Zinvest="C"),Zamt) Also tried this which resulted in #VALUE =SUMPRODUCT(--(Zmth=B2),--(Zbuscode=18),--OR(--(Zinvest="A"),--(Zinvest="B"),--(Zinvest="C")),Zamt) Any Suggestions? Many Thanks TW |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Storing selection & using the saved selection adress later | Excel Programming | |||
| Object Type of a selection... counting rows in a selection | Excel Programming | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Threaded Mode
