itsalllowercase
New Member
- Joined
- Aug 25, 2013
- Messages
- 15
Hey Guys,
I'm working on an Excel project and been pretty unsuccessful. I hope someone can help me.
I have a table with the following values:
<TBODY>
</TBODY>
I need it to:
1) Count all cells with Site 1, Site 2 and Site 3. (This I was able to do with COUNTIF).
2) Count all trainees from Site 1.
3) Count all trainees from Site 1 under Department 1.
Is there an easy way to do this?
Thanks in advance!
I'm working on an Excel project and been pretty unsuccessful. I hope someone can help me.
I have a table with the following values:
Site | Name | Status | Tenure | Department |
Site 1 | ABC, Joe | Trainee | Dep 1 | |
Site 1 | DEF, Jane | Regular | Dep 2 | |
Site 2 | GHI, Joe | Regular | Dep 3 | |
Site 3 | JKL, Jim | Trainee | Dep 7 |
<TBODY>
</TBODY>
I need it to:
1) Count all cells with Site 1, Site 2 and Site 3. (This I was able to do with COUNTIF).
2) Count all trainees from Site 1.
3) Count all trainees from Site 1 under Department 1.
Is there an easy way to do this?
Thanks in advance!