TRYING TO COUNT MULTIPLE DATA IN A COLUMN

Brandon Kennedy

looking to count all the data from 4P100,4P200,4P500 etc in one row

the deal I have is 0-500

501-1000

1001-1500

I am not wiz at this but I am trying to learn

heyjay

=COUNTIFS(
[Column Name]:[Column Name], 
CONTAINS("4P1", @cell))

Use the function CONTAINS is searching for partial match.

Brandon Kennedy

I will try that thank you