Hi,
I need help with a formula that can count a range of cells that include figures, based on another column which contains text.
I have salary information in column C, and i need to calculate headcount based on department name in column B, so I want to add up how many employees salaries relate to department "Delivery"
e.g. out of 75 staff it should say 20
Any help would be great, thanks!
I don't understand how salary plays into this. Don't you just want to count how many in Column B have the department "Delivery"?
Had you intended to attach a sheet?
Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
or did you simply want:
=COUNTIF(B:B,"Delivery")
Sorry, I've attached a sheet now
Different months have zero values in so I don't want to include them in the monthly total
In C67, copied across and down:
=COUNTIFS(C$5:C$63,"<>"&0,$B$5:$B$63,$B67)
Excellent Glenn Excellent!! Thanks.
What if I wanted to also include another section, so C$5:C$63 and also C$67:C$72, how can I include that?
Once again, can you post a sampel so that can see your data structure?
Sorry Glenn, here you go
Yea, OK. For a moment I thought that this was going to require a bit of a monster, but no. Just extend the ranges. The subtotals can't affect it as they are not classified as D, WP, etc, in column B.
=COUNTIFS($B$5:$B$72,$B75,C$5:C$72,"<>0")
will work perfectly, copied across and down.
That's excellent, thanks so much Glenn!
You're very welcome.
Last edited by Glenn Kennedy; 09-08-2016 at 07:33 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks