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

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.

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 ConfirmedThe 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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History