Hello,
I now need help counting all my FT employees per month.
If you see the attached file, I have an existing formula that I used to determine how many employees total per month I have for 2015.
But now I need to know how many FT employees per month.
I'm not able to attached my file????
check the size of the file
also - make sure there is dummy info - this is a public forum
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
\\primrose-fs1\users$\shaugen\Desktop\excel help.JPG
If you change the entries in column G to TEXT entries instead of formatted dates...
Entered in J5 and copied down:
=SUMPRODUCT(--(TEXT(B$5:B$11,"mmm yyyy")=G5),--(C$5:C$11="Full Time"))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Didn't work, see below:
Still didn't work even after changing column G to TEXT
Last edited by gemblu; 03-02-2016 at 06:23 PM.
You're going to have to post a sample spreadsheet file (not a pic) so we can see what the problem might be.
Make the file as SMALL as possible but still demonstrating the problem.
Does this work?
This works in the sample file.
=COUNTIFS(B$5:B$9,">="&G5,B$5:B$9,"<="&EOMONTH(G5,0),C$5:C$9,"Full Time")
However, none of the sample data met any of the conditions so all the results were correctly 0. I did change some data to meet the conditions and those were correctly counted.
It didn't work. I keep getting 0 full time employees
Here's your sample file with the formula implemented. I added a few more data rows.
Or try this: =SUMPRODUCT(--(TEXT($B$5:$B$15,"mmm yyyy")=TEXT(G5,"mmm yyyy")),--($C$5:C$15="Full Time"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks