Trending in Formulas and Functions
Counting items from a multiple drop down list
I have a list of action items that can be assigned to several departments by using a multiple drop down list with dept. names in the assigned column I am trying to create a summary sheet to count the number assigned I have tried both Contains & HAS But my answer is 0 - Just using the count if gets me 23 and there are 2…
How to make sheet summary with multiple drop down column?
I am hoping someone might be able to guide me. I am trying to count how many of certain courses people are interested in. All options populate into the same column. Is there a way to do something like: =COUNTIF(Which courses are you interested in?, Project Management)
Pull the Most Recent Submission
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.