| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range in Other workbook - not working in SUMPRODUCT formula?
I have created named range in from other workbook.
When I use it in Counta(ccc) it gives correct answer. However if I use in the sumproduct formula, I get #NA error. The formula is =SUMPRODUCT(-(ccc=A6)*-(rrr<"")) (I want count of non blank cells in rrr range where range ccc has a value equall to A6) I suspect that something is wrong with formula. Pl help urgently. Regards, Madiya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use a named range in SUMPRODUCT? | Excel Discussion (Misc queries) | |||
| Named Range Links not working | Links and Linking in Excel | |||
| Sumproduct & Named range | Excel Discussion (Misc queries) | |||
| Formula not working when letter A is used in a named range | Excel Discussion (Misc queries) | |||
| working with a named range | Excel Programming | |||
Threaded Mode
