Countif(and( Statement

  • Thread starter Thread starter Tappie
  • Start date Start date
T

Tappie

Hi

I am currently trying to count some data in Excel 2000.

I have two columns and only want to count when specific
criteria matches in both columns.

I am trying to use the following command but it does not
work, has anyone got any ideas ?

=countif(and('Master Sheet'!F:F="Stage 1",'Master Sheet'!
G:G="Fred Jones"))

Thanks in advance.....
 
Back
Top