| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formular Question
Anyone can teach me how to solve my problems.. thk in advance!! =)
Refer to the attached file.. 1. how to count the no. of "A" in column B of in sheet 1? I used the formula in column B so can't just use "=COUNTIF(B2:B4,"A") 2. how to count the no. of staff change from A to B in June? annie |
|
#2
|
|||
|
|||
|
You will need to post a text sample of data, people will not open an
attachment. You could use =COUNTIF(B2:B4,"A") in B1! -- HTH Bob Phillips "annie" <annie@^^ wrote in message ... Anyone can teach me how to solve my problems.. thk in advance!! =) Refer to the attached file.. 1. how to count the no. of "A" in column B of in sheet 1? I used the formula in column B so can't just use "=COUNTIF(B2:B4,"A") 2. how to count the no. of staff change from A to B in June? annie |
|
#3
|
|||
|
|||
|
Thanks Bob. I got it done. Thanks again~~ =)
"Bob Phillips" ¦b¶l¥ó ¤¤¼¶¼g... You will need to post a text sample of data, people will not open an attachment. You could use =COUNTIF(B2:B4,"A") in B1! -- HTH Bob Phillips "annie" <annie@^^ wrote in message ... Anyone can teach me how to solve my problems.. thk in advance!! =) Refer to the attached file.. 1. how to count the no. of "A" in column B of in sheet 1? I used the formula in column B so can't just use "=COUNTIF(B2:B4,"A") 2. how to count the no. of staff change from A to B in June? annie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reducing Formular length | Excel Discussion (Misc queries) | |||
| Question when Copying an Existing Worksheet | Excel Worksheet Functions | |||
| array formular | Excel Worksheet Functions | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
