Creating a formula that counts occurances

's Computer Specifications

If cells AG3 through AW3 can have a 1, 2, 3, 4, or 5 code entered. What
formula is needed for cell AX3, if I want to count the number of times a 1
was noted/occurred in cells AG3 through AW3?

's Computer Specifications

Look in HELP for the COUNTIF() function

--
Kind regards,

Niek Otten

"smoutsat" <(E-Mail Removed)> wrote in message
news:924BC458-ECB4-42A8-A215-(E-Mail Removed)...
> If cells AG3 through AW3 can have a 1, 2, 3, 4, or 5 code entered. What
> formula is needed for cell AX3, if I want to count the number of times a 1
> was noted/occurred in cells AG3 through AW3?
>
>

's Computer Specifications

That is what I was looking for. Thank you!

"Niek Otten" wrote:

> Look in HELP for the COUNTIF() function
>
> --
> Kind regards,
>
> Niek Otten
>
> "smoutsat" <(E-Mail Removed)> wrote in message
> news:924BC458-ECB4-42A8-A215-(E-Mail Removed)...
> > If cells AG3 through AW3 can have a 1, 2, 3, 4, or 5 code entered. What
> > formula is needed for cell AX3, if I want to count the number of times a 1
> > was noted/occurred in cells AG3 through AW3?
> >
> >
>
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating report with date counts	Chipgiii	Microsoft Access	1	10th Feb 2010 08:00 PM
Creating queries asking for counts	John	Microsoft Access Queries	6	4th Dec 2009 09:46 PM
Creating A Chart that counts repitition (don't know name)	Firebird	Microsoft Excel Charting	1	4th Oct 2008 02:51 PM
COUNTIF Formula for all occurances of X	=?Utf-8?B?WWFuWWFu?=	Microsoft Excel Misc	2	26th Apr 2007 03:17 AM
I a formula that outputs the number of occurances of a specific t.	=?Utf-8?B?QXJ0ZW0=?=	Microsoft Excel Misc	1	24th Feb 2005 02:00 AM