How do I hide a value in my totals worksheet ?

J

J

Hi,

I am tallying how many vehicles I have sold this month.
In my calculations I only want to COUNT all new vehicles. Any demonstrators
that I have sold I do not want to tally.

Can anyone help me with the formula or condition I can use ?
 
D

Dave Peterson

If you have a column with the status of the car, maybe you could use:

=countif(a2:a99,"new")
 
Top