# COUNTIF HELP

I'm summarising and want to count a Project Status columns

Have a sheet per colleague and want to do formula that would add up how many On HOLD projects there in total across all of those colleague sheets?

Tags:

• ✭✭✭✭✭✭

I would suggest having the total on each of the individual sheets and then cell linking to the master sheet. Then you can use a basic SUM function on the master sheet.

If you wanted to go with a single formula to reference all sheets, then you would start off with your COUNTIFS for one sheet, then replicate it for the second sheet and add them together, then add a third COUNTIFS for the third sheet, so on and so forth:

=COUNTIFS({First Sheet}, "On Hold") + COUNTIFS({Second Sheet}, "On Hold") + COUNTIFS({Third Sheet}, On Hold")..........................

• ✭✭✭✭✭✭

I would suggest having the total on each of the individual sheets and then cell linking to the master sheet. Then you can use a basic SUM function on the master sheet.

If you wanted to go with a single formula to reference all sheets, then you would start off with your COUNTIFS for one sheet, then replicate it for the second sheet and add them together, then add a third COUNTIFS for the third sheet, so on and so forth:

=COUNTIFS({First Sheet}, "On Hold") + COUNTIFS({Second Sheet}, "On Hold") + COUNTIFS({Third Sheet}, On Hold")..........................

• Thanks Paul, appreciate your time taken to respond and very clear!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!