How do I hide a value in my totals worksheet ?
 

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 ?

How do I hide a value in my totals worksheet ?
 

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

=countif(a2:a99,"new")



J wrote:

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 ?

--

Dave Peterson