Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Counting Based on Two Items
I am making a sheet to track the number of proposals we send out and how many turn into projects.
I want to be able to count them by which Project Manager did it. So I have a PM field for the Project Managers initials. I was using fields for each PM's Proposals. The formula I used was COUNTIF(PM:PM, "RM") for example and it seems to work OK.
The part I am having problems with is getting the number of ones for each PM that turn into projects.
What I am looking for is a count of the projects that a particular PM was successful getting.
I have a field for Project Number which only has a value if the proposal turned into a project.
How do I count the number of projects attributed to each PM?
Is there a cleaner way to do this?
Thanks,
Comments
-
Try this out? I would have 2 values, Count if PM and Count if "successful", to replace Jimmy and 7
=COUNTIFS([Value 1]124:[Value 1]126, "Jimmy", [Value 2]124:[Value 2]126, 7)
EXAMPLE: Count the number of times the name 'Jimmy' and the number 7 appear on the same row
Applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
-
The second value can be anything. It does not have a specific number.
-
Replace the 7 in Henry's formula with this:
NOT(ISBLANK(@cell))
If the proposal is blank, it won't be counted. Otherwise, it will.
Craig
-
Works fine now. Thanks.
