Countifs Find Formula Help

anuelle

Hello! I'm working on a formula to capture individuals involvement on projects. I currently have the following formula set up to track projects:

=COUNTIFS({Contact Columns}, FIND("First Last", @cell) > 0)

I would like to add a condition to this so the formula only looks at projects with a status of "In Progress". I've tried adding another "If" statement to the formula but keep getting an error message. Does anyone know if/how I can add this condition to the formula?

Thanks!

Leibel S

@anuelle

See below, you can keep on adding ranges and criteria... Add/setup the cross sheet reference as needed

=COUNTIFS({Contact Columns}, FIND("First Last", @cell) > 0,{Project Status},@cell="In Progress")

Ipshita

Hi @anuelle,

Try this formula - it will work :)

=COUNTIFS(Owner@row, FIND("Sofia", @cell) > 0, Status@row, "In Progress")

Hope this helps,

Cheers!

Ipshita

anuelle

@Leibel S I've tried your suggestion and am still getting an "Incorrect Argument Set" error. Could this be due to the fact it's a cross-reference formula?