| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Blank cells using evaluate(=sumproduct)
Please somebody, tell me why this doesn't work.
I am using version 2003. Evaluate("=sumproduct((F25:f136=""abc"")*(j24:j136 =""))") I have used the below directly in the worksheet and it works fine. {=sum((F25:f136=""abc"")*(j24:j136=""))} Please assist. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Blank cells using evaluate(=sumproduct)
Gwen,
There are unequal number of elements in the two arrays. Is that the problem or is this an error that crept in while posting to the newsgroup? "Gwen" wrote: Please somebody, tell me why this doesn't work. I am using version 2003. Evaluate("=sumproduct((F25:f136=""abc"")*(j24:j136 =""))") I have used the below directly in the worksheet and it works fine. {=sum((F25:f136=""abc"")*(j24:j136=""))} Please assist. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Blank cells using evaluate(=sumproduct)
No, that is not the problem.
The array elements are correct in my code. It should be Evaluate("=sumproduct((F25:f136=""abc"")*(j25:j136 =""))") Thanks. "Alok" wrote: Gwen, There are unequal number of elements in the two arrays. Is that the problem or is this an error that crept in while posting to the newsgroup? "Gwen" wrote: Please somebody, tell me why this doesn't work. I am using version 2003. Evaluate("=sumproduct((F25:f136=""abc"")*(j24:j136 =""))") I have used the below directly in the worksheet and it works fine. {=sum((F25:f136=""abc"")*(j24:j136=""))} Please assist. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Blank cells using evaluate(=sumproduct)
I think what you need is
Evaluate("=sumproduct(--(F25:f136=""abc"")*--(j25:j136=""""))") This is because inside the double quotes, two double quotes become one double quote. "Gwen" wrote: No, that is not the problem. The array elements are correct in my code. It should be Evaluate("=sumproduct((F25:f136=""abc"")*(j25:j136 =""))") Thanks. "Alok" wrote: Gwen, There are unequal number of elements in the two arrays. Is that the problem or is this an error that crept in while posting to the newsgroup? "Gwen" wrote: Please somebody, tell me why this doesn't work. I am using version 2003. Evaluate("=sumproduct((F25:f136=""abc"")*(j24:j136 =""))") I have used the below directly in the worksheet and it works fine. {=sum((F25:f136=""abc"")*(j24:j136=""))} Please assist. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells using EVALUATE | Excel Discussion (Misc queries) | |||
| Sumproduct counting blank cells, dates, capturing last row | Excel Programming | |||
| =SUMPRODUCT formula is counting the blank cells as well as zero's | Excel Worksheet Functions | |||
| =SUMPRODUCT formula is counting the blank cells as well as zero's | Excel Worksheet Functions | |||
| sumproduct--counting--zero--blank cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
