| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Function?
Thanks everyone. One simple little open paren.
"Johnnie" wrote: A B C 1 Company 1 10 Company 1 2 Company 2 10 3 Company 3 10 4 Company 2 8 5 Company 1 7 6 Company 1 6 7 Company 3 8 In C2 I am using this function =sumproduct(--$a$1:$a$7="Company 1"),b1:b7) I keep getting an error and I am not sure what I am missing. Any help is great appreciated. Johnnie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array function | Excel Discussion (Misc queries) | |||
| OR function in array-entered IF function | Excel Worksheet Functions | |||
| How To Do This Array Function | Excel Worksheet Functions | |||
| Help for Array function | Excel Worksheet Functions | |||
| array function | Excel Worksheet Functions | |||
![Johnnie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
