| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct problem
it did work, thanks a lot.
"Dave Peterson" wrote: Maybe a small variation that avoids text in column B: =sumproduct(--(C1:C7<""),B1:B7) nada wrote: hi all, i entered in B2 =if(LEN A2=0,"",A2) so if A2 is blank B2 will appear blank but for example if i tried to enter in another cell the following: sumproduct((C1:C7<"")*B1:B7) it returns error value as it sees B2 not blank, can anyone help me? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct problem. | Excel Discussion (Misc queries) | |||
| Sumproduct problem | Excel Worksheet Functions | |||
| SUMPRODUCT PROBLEM | Excel Worksheet Functions | |||
| sumproduct problem? | Excel Discussion (Misc queries) | |||
| sumproduct problem | New Users to Excel | |||
Threaded Mode
