assign value based on criteria and total

's Computer Specifications

I have cells from c9 to AB9 that are populated with 1 of 4 different letters.
I have been able to get a count based on the criteria but what I need to do
is this:
If c9 to ab9 have an "a" in it count as 1 but if it has a "b" in it count as
..5. Is this possible.
Thanks for any suggestions

's Computer Specifications

Hi,

Maybe this

=COUNTIF(C9:AB9,"a")+(COUNTIF(C9:AB9,"b")/2)

Mike

"rascal" wrote:

> I have cells from c9 to AB9 that are populated with 1 of 4 different letters.
> I have been able to get a count based on the criteria but what I need to do
> is this:
> If c9 to ab9 have an "a" in it count as 1 but if it has a "b" in it count as
> .5. Is this possible.
> Thanks for any suggestions

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign price category based on multiple record criteria	hepsedam@gmail.com	Microsoft Access	9	16th Oct 2008 08:31 PM
Re: looping to assign number based on entered criteria	Joseph Meehan	Microsoft Access	0	23rd Jan 2007 07:55 PM
get a total based on criteria in two columns	=?Utf-8?B?cmFy?=	Microsoft Excel Worksheet Functions	2	22nd Nov 2005 02:24 PM
find total based on 2 criteria	=?Utf-8?B?RG93bmluZ0RldmVsb3BtZW50cw==?=	Microsoft Access Queries	1	18th Jul 2005 07:10 PM
Assign ID based on condition(criteria)	changeable	Microsoft Excel Programming	1	7th Nov 2004 02:42 PM