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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
Sorry I meant "Out Of Service" not "0"
"Steved" wrote: Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
I can't see that formula has anything to do with "0",
it counts the string "Valley Flyer" and you could be more efficient and use COUNTIF instead in this case -- Regards, Peo Sjoblom "Steved" wrote in message ... Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
Do you mean if the result is 0 return something other than 0 like a blank
cell? Try this: =IF(COUNTIF($D$2:$D$1989,"Valley Flyer"),COUNTIF($D$2:$D$1989,"Valley Flyer"),"") -- Biff Microsoft Excel MVP "Steved" wrote in message ... Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
Where would Out of Service be?
-- ** John C ** "Steved" wrote: Sorry I meant "Out Of Service" not "0" "Steved" wrote: Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
Thankyou
"T. Valko" wrote: Do you mean if the result is 0 return something other than 0 like a blank cell? Try this: =IF(COUNTIF($D$2:$D$1989,"Valley Flyer"),COUNTIF($D$2:$D$1989,"Valley Flyer"),"") -- Biff Microsoft Excel MVP "Steved" wrote in message ... Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
That answer made me even more confused
-- Regards, Peo Sjoblom "Steved" wrote in message ... Thankyou "T. Valko" wrote: Do you mean if the result is 0 return something other than 0 like a blank cell? Try this: =IF(COUNTIF($D$2:$D$1989,"Valley Flyer"),COUNTIF($D$2:$D$1989,"Valley Flyer"),"") -- Biff Microsoft Excel MVP "Steved" wrote in message ... Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
Hello Peo from Steved
You actually answered yourself by refering to "Valley Flyer" And you gave me the answer I required and that was Countif Cheers. ps Now you are now back to normal ( Unconfused ). "Peo Sjoblom" wrote: I can't see that formula has anything to do with "0", it counts the string "Valley Flyer" and you could be more efficient and use COUNTIF instead in this case -- Regards, Peo Sjoblom "Steved" wrote in message ... Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
You're welcome!
-- Biff Microsoft Excel MVP "Steved" wrote in message ... Thankyou "T. Valko" wrote: Do you mean if the result is 0 return something other than 0 like a blank cell? Try this: =IF(COUNTIF($D$2:$D$1989,"Valley Flyer"),COUNTIF($D$2:$D$1989,"Valley Flyer"),"") -- Biff Microsoft Excel MVP "Steved" wrote in message ... Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore "0"
Me too!
????? -- Biff Microsoft Excel MVP "Peo Sjoblom" wrote in message ... That answer made me even more confused -- Regards, Peo Sjoblom "Steved" wrote in message ... Thankyou "T. Valko" wrote: Do you mean if the result is 0 return something other than 0 like a blank cell? Try this: =IF(COUNTIF($D$2:$D$1989,"Valley Flyer"),COUNTIF($D$2:$D$1989,"Valley Flyer"),"") -- Biff Microsoft Excel MVP "Steved" wrote in message ... Hello from Steved =SUMPRODUCT(--($D$2:$D$1989="Valley Flyer")) Please how to I tell the above formula to ignore "0" if found. Thankyou. |
Reply |
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 |