| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
Hello from Steved
=SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I ignore the "Number stored as text" error message permane. | Excel Discussion (Misc queries) | |||
| Ignore "a(n)", "the" in A-Z sort | Excel Discussion (Misc queries) | |||
| Having a pie chart ignore data fields equal to "0" | Excel Discussion (Misc queries) | |||
| use "button" to make calculation ignore a cell | Excel Worksheet Functions | |||
Threaded Mode
