# COUNTIF across multiple sheets

Options

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

• ✭✭✭✭✭✭
edited 08/12/23
Options

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

• Options

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

• ✭✭✭✭✭✭
edited 08/12/23
Options

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

Jacob Stey

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!