Countif multiple criteria

Mohammed khan

Hi,

I would like to extract the number of tasks completed by a certain team using different sheet

Project team IT

Compleated

Not Started

Inprogress

 

Project team ERP

Compleated

Not Started

Inprogress

Andrée Starå

Hi Mohammed,

Do you want to collect information from other sheets? How many sheets?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD