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
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
