Counting Values in Two Tables with Condition

[VegasL]

Hello,

I am trying to count the values in column a, if the corresponding value in column b is not blank.

desired result is in 7, in cell g3 but getting 99.

Thanks

Please see attachement

The highlighted values in column a & b are what should be counted.

[oeldere]

With pivot table or countifs.

See the attached file.

[micope21]

Hi

Try this

Please Login or Register  to view this content.

[VegasL]

Thanks guys both worked. Appreciate your help.