Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Creating a formula that counts occurances
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Creating a formula that counts occurances
 |
Creating a formula that counts occurances |
|
|
Thread Tools | Rate Thread |
08-12-2005, 05:29 PM
|
#1 |
|
Guest
Posts: n/a
|
Creating a formula that counts occurances
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? |
|
|
08-12-2005, 05:34 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Creating a formula that counts occurances
Look in HELP for the COUNTIF() function
-- Kind regards, Niek Otten "smoutsat" <smoutsat@discussions.microsoft.com> wrote in message news:924BC458-ECB4-42A8-A215-09A1996EAA1D@microsoft.com... > 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? > > |
|
|
|
08-12-2005, 09:29 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: Creating a formula that counts occurances
That is what I was looking for. Thank you!
"Niek Otten" wrote: > Look in HELP for the COUNTIF() function > > -- > Kind regards, > > Niek Otten > > "smoutsat" <smoutsat@discussions.microsoft.com> wrote in message > news:924BC458-ECB4-42A8-A215-09A1996EAA1D@microsoft.com... > > 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 | |
| Rate This Thread | |
|
|
