How to Count the specific Values in the Column?

[#1]

Hi QV Team,

I need to count only the "X' Values in the NewCars Column. Pls help me out. Pls see the attachments.

[amit_saini]

Hi ,

Like this???

Thanks,
AS

[amit_saini · Accepted solution]

Try this also:

count(if(match([New Cars],'X'),[New Cars]))

Thanks,

AS

[#4]

No I just want to create a table and need to get the Total of NewCars and UsedCars.

[amit_saini]

Use count(if(match([New Cars],'X'),[New Cars])) than , you will get your result.

Thanks,
AS

[amit_saini]

Like this???

Thanks,

AS