Hi I'm trying to count the number of cells in a range if the specified cell in a different range is matching specific criteria. In the example below i want to count the number of cells in column b if column a= 1234. I'm currently using a countif formula but getting the error that too many arguments are used, if i change it to countifs then it says i'm using too few arguments. My formula is COUNTIF(A1:A4, "1234", B1:B4). I'm new to this so i could be completely wrong on what i'm trying to do here. Thanks!