Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

COUNTIF with WIldcards

I have a survey sheet where all columns start with specifc chars: D-, I-, O-.  Each contains differing descriptions following the "-".  I want to create a sum of all "D-", "I-", etc. disregarding the descriptive text following the "-".  I am using COUNTIF([Column1]:[Column X],="D-*") with no luck.  Always returns "0" unless I specifically add ALL the text.  This same function works fine in Excel counting all columns with "D- . . . ."

Thanks

Tags:

Comments

This discussion has been closed.