# Count the same content of a cell on several sheets

edited 08/31/21

Hello everyone,

I am trying to count the number of cells in about 40 sheets in which "SLF-FP-001 Commercial" appears in a "Green" status.

Is-it possible ?

I know how to do it for a single sheet:

=SUM((COUNTIFS({Sheet 1 Range 1}; "SLF-FP-001 Commercial"; {Sheet 1 Range 2}; "Green")))

Thank you very much for your help.

• ✭✭✭✭✭✭

Ok I will check it

PMP Certified

[email protected]

www.mobilproject.it

• ✭✭✭✭✭✭

Hope you are fine, yes you can do that for repeating the same formula by changing the reference for each sheet and sum the results for all sheets, the following is a sample for 2 sheets:

```=COUNTIFS({Sheet 1 Range 1}, "SLF-FP-001 Commercial", {Sheet 1 Range 2}, "Green")
+ COUNTIFS({Sheet 2 Range 1}, "SLF-FP-001 Commercial", {Sheet 2 Range 2}, "Green")
```

PMP Certified

[email protected]

www.mobilproject.it

• edited 08/31/21

Thank you for this reply Bassam Khalil,

Is this possible in this formula ?

=SUM(COUNTIFS({PDCA Devis SLF-FP-002 Plage 2}; "SLF-FP-001 Commercial"; {PDCA Devis SLF-FP-002 Plage 1}; "Vert");COUNTIFS({PDCA Industrialisation Modelage SLF-FP-003 Plage 2}; "SLF-FP-001 Commercial"; {PDCA Industrialisation Modelage SLF-FP-003 Plage ;"Vert")

Thank you

• ✭✭✭✭✭✭

Why you are using SUM function with COUNTIFS, if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : [email protected]

PMP Certified

[email protected]

www.mobilproject.it

• Done !

• ✭✭✭✭✭✭

Ok I will check it

PMP Certified

[email protected]

www.mobilproject.it