| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct; two conditions; no list
I have a list that is broken up in different parts. The list is broken up by
blank cells and by text. My formula works if I only include a part of the sheet =SUMPRODUCT((Sheet1!A5:A17=A3)*(Sheet1!T5:T17="Gew erbe")*Sheet1!K5:K17) but not if I include the whole column: =SUMPRODUCT((Sheet1!A:A=A3)*(Sheet1!T:T="Gewerbe") *Sheet1!K:K) Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with conditions | Excel Discussion (Misc queries) | |||
| SUMPRODUCT with conditions | Excel Worksheet Functions | |||
| Conditions in sumproduct | Excel Worksheet Functions | |||
| sumproduct three conditions | Excel Worksheet Functions | |||
| Can wildcards be used in SUMPRODUCT conditions | Excel Worksheet Functions | |||
Threaded Mode
