Count Date + N/A

RobNY2

I have a columns "LAN M Actual Complete" and another column "2nd Touch Indicator"

I need total Site complete: count if "LAN M Actual Complete" has a date and "N/A" in the "2nd Touch Indicator column"

Dont' count if "LAN M Actual Complete" has a date or no date and "2nd Touch Indicator" is blank or something else besides "N/A"

Only count if there is a date on "LAN M Actual Complete and N/A on "2nd Touch Indicator" columns

Thanks

Rob

Genevieve P.

Hi @RobNY2

I would use a COUNTIFS Function (plural) for this! Try something like:

=COUNTIFS({Actual Complete Column}, <> "", {2nd Touch Indicator Column}, "N/A")

The <> means does not equal and then "" means blank, so you're looking to see if the Complete column is not blank and the indicator column is equal to "N/A" (and only "N/A").

I've written it as a cross-sheet formula, but depending on your plan type you could use a Sheet Summary field for this calculation. In this instance you'd want to swap out the {cross sheet references} for [column references] like so:

=COUNTIFS([LAN M Actual Complete]:[LAN M Actual Complete], <> "", [2nd Touch Indicator]:[2nd Touch Indicator], "N/A")

Let me know if this works for you!

Cheers,

Genevieve