COUNTIF across multiple sheets

nick.wilson

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")

SteyJ

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!

nick.wilson

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")

SteyJ

nick.wilson

Aug 12, 2023

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