Hi Folks
I have attached an EXCEL 2010 file to the post.
On sheet 1 I have a list of departments, names of emplyees and length of service indicated by the letter 'X'
On sheet 2, I would like to be able to count the 'X''s based on the department
Eg 2 people with 5yrs in Admin
Is there a COUNTIF or SUMIF formula I could use?
I am not getting this
Thank You
Try this...
Entered in B3:
=COUNTIFS(Sheet1!$A:$A,$A3,Sheet1!C:C,"X")
Copy across to D3 then down to B12:D12
Nice name. Are you by any chance a former President of the U.S. ?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hahahahah!
No.
Just a jackass who loves doing everything in Excel.
However, I'm several brain cells short of a single brain cell.
Thank You!!
I'm gonna add to your rep.
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks