What I want my logic to say:
If a value in column "A" is greater than another cell value (A3), and a value in column C includes the string "non-toil", then add a count for all of the rows that satisfy these conditions.
The code I have in my cell is:
=IF(RawData!A1:A2000,<A3, COUNTIF(RawData!C1:C2000, "*non-toil*",))
Aucun commentaire:
Enregistrer un commentaire