Solved I Need To Count Confirmed Enquiries In Excel

March 4, 2013 at 12:47:49
Specs: Windows XP
I am putting toegtehr a spread sheet for enquires. All i have to do is calculate which enquires are confirmed and which are lost. i thought of colour (green confirmed, red lost) but how would you calculate the totals?

Any help or other suggestions would be hugely appreciated.

thanks
Jenny


See More: I Need To Count Confirmed Enquiries In Excel

Report •

#1
March 4, 2013 at 13:12:41
First a posting tip:

When posting in a help forum such as this, please try to use a subject line that is relevant to the contents of your post. If everyone used a generic subject line like "I Need Help With Excel" we wouldn't be able to tell one post from another and the archives would be useless for searching.

I have edited the subject line of your post to make it relevant to your question.

Please take a look at some of the other subject lines in this forum to get an idea of how other members title their posts.

Thanks!

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 4, 2013 at 13:20:41
✔ Best Answer
Excel has a function called COUNTIF.

It will count the number entires in a range that match the criteria given.

For example, for the following example, both of these formulas will return 3:

=COUNTIF(A1:A4,"=Confirmed")
=COUNTIF(A1:A4,A1)

       A
1  Confirmed
2  Confirmed
3  Lost
4  Confirmed

The first formula has the criteria "hardcoded" into the formula (the quotes and equal sign are required), the second formula uses the value in A1 as the criteria (no quotes or equal sign).

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question