Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumproduct external reference
I put up a previous post that perhaps was not as clear as it could be.
Simple question: When using an external reference with SUMPRODUCT, is there a symbol that can be placed into the external reference cell to indicate 1) blanks 2) non-blanks Thanks anand |
#2
|
|||
|
|||
Why don't you just stick to the one thread rather than scattering questions
all over the group. -- HTH RP (remove nothere from the email address if mailing direct) "anand" wrote in message ... I put up a previous post that perhaps was not as clear as it could be. Simple question: When using an external reference with SUMPRODUCT, is there a symbol that can be placed into the external reference cell to indicate 1) blanks 2) non-blanks Thanks anand |
#3
|
|||
|
|||
I will do that. anand "Bob Phillips" wrote: Why don't you just stick to the one thread rather than scattering questions all over the group. -- HTH RP (remove nothere from the email address if mailing direct) "anand" wrote in message ... I put up a previous post that perhaps was not as clear as it could be. Simple question: When using an external reference with SUMPRODUCT, is there a symbol that can be placed into the external reference cell to indicate 1) blanks 2) non-blanks Thanks anand |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
dynamic external cell reference | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
External Reference | Excel Discussion (Misc queries) |