Hello all ,I have two columns to pull info from in my sheet

Tony Pipitone

One column Is State and one column is KEO Estimation Range, one contains In Progress and the other initials of the estimator . My goal is to determine how many rows are in progress and how many belong to the estimator in question ? simply put if I have 20 projects in progress and 2 belong to the initials DR ,that is the end result im trying to perform with the formula / the result I'm getting is unparsable / appreciate any help I can get, thank you

Tony P

Tony Pipitone

Sorry I failed to leave the formula

=COUNTIF({State}, ="In Progress"),AND({KEO Estimation Range 1},= "DR"))

Genevieve P.

Hi @Tony Pipitone

Instead of COUNTIF, singular, try COUNTIFS, plural!

=COUNTIFS({State}, "In Progress", {KEO Estimation Range 1}, "DR")

See: COUNTIFS Function

Cheers,

Genevieve

Tony Pipitone

Hello Genevieve / your formula worked like a charm, thank you TP

Genevieve P.

Glad I could help! 🙂