How do I hide a value in my totals worksheet ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
If you have a column with the status of the car, maybe you could use:

=countif(a2:a99,"new")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas in Columns and transpose to rows? 5
Excel Count If Formula Question 1
Countif Formulas 2
Sumproduct, but errors in column 6
I want to tally my sheet 6
How to ignore a column of numbers in Grand Total for rows 1
Abrupt change in formula results using sumproduct 4
Show - in cell 1

Back
Top