COUNTIF with WIldcards

david.brown20311

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

J. Craig Williams

David

Try using the LEFT function like this:

=COUNTIF([Column1]:[Column X], LEFT(@cell, 2) = "D-")

repeat for other letters

I hope this helps.

Craig

david.brown20311

This worked great.  Thanks