Hi, can someone help me with this, I am trying to use the countif function like this
=COUNTIF(Sheet1!C2:C1000,"128MB PC100 SDRAM") and (Sheet1!E2:E1000,"Stock")
What I want is the system to count every row which has the two conditions met but it doesn't work. Is it possible to use the AND argument with COUNTIF or is there a better way?
Cheers
Ben
=COUNTIF(Sheet1!C2:C1000,"128MB PC100 SDRAM") and (Sheet1!E2:E1000,"Stock")
What I want is the system to count every row which has the two conditions met but it doesn't work. Is it possible to use the AND argument with COUNTIF or is there a better way?
Cheers
Ben