COUNTIF HELP

Mark Tserkezie

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?

Paul Newcome

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

Paul Newcome

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

Mark Tserkezie

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

Paul Newcome

Happy to help. 👍️