How to calculate 2 condition from 2 different column and link it to another sheet

Happy

Hi I would like to calculate my current sheet records with 2 different condition which was "on going" at the same time it is an "Valid Issue"

Both "on going" status, and issue type "Valid Issue" is from different column. How do I manage to calculate the on going cases with valid issue only, and I would to calculate them from a new sheet.

Genevieve P.

Hi @Happy

Are you looking to simply count how many rows in your first sheet have those two criteria?

If so, you could use a COUNTIFS for this! For example:

=COUNTIFS({Status Column Sheet 1}, "On Going", {Issue Column Sheet 1}, "Valid Issue")

Here's more information:

• COUNTIFS Function
• Create cross sheet references to work with data in another sheet

Cheers,

Genevieve

Genevieve P.

Hi @Happy

Are you looking to simply count how many rows in your first sheet have those two criteria?

If so, you could use a COUNTIFS for this! For example:

=COUNTIFS({Status Column Sheet 1}, "On Going", {Issue Column Sheet 1}, "Valid Issue")

Here's more information:

• COUNTIFS Function
• Create cross sheet references to work with data in another sheet

Cheers,

Genevieve

Happy

Hi @Genevieve P.

Thanks for your tips, Im able to get the data now.

Genevieve P.

Great! I'm glad I could help 🙂