COUNTIF across multiple sheets
How do I use the following formula to pull information from the "place holder" field from multiple sheets?
=COUNTIF([Assigned To]:[Assigned To], "place holder")
Answers
-
Hello @nick.wilson,
Highlight "place holder" and then select "Reference Another Sheet"
From here you can select which cell value you would like to have as the placeholder in the other sheet.
=COUNTIFS([Assigned To]:[Assigned To], "place holder")
If you need to reference multiple sheets, you can do this formula multiple times, or you can do "=COUNTIFS" like this
=COUNTIFS([Assigned To]:[Assigned To], "place holder", [Assigned To]:[Assigned To], "place holder 2")
Hope this helps!
Sincerely,
Jacob Stey
-
That worked but I have one more question. How would I create a formula that will give you the sum of a list of numbers in column based on the Assigned To column? I tried the one below but it does not give you the sum per Assigned To contacts, just the sum per the column.
=SUM([Assigned To]:[Time per task], "placeholder contact")
-
Do you want to count how many tasks are assigned to a specific contact? I am wondering why you are using Time Per Task in your range when you can just do
=SUMIF([Assigned To]:[Assigned To], "Placeholder contact")Hope this helps
Sincerely,
Jacob Stey
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
