Hi

I have a large list. I need a formula that will count all the values in the list that are lower than a certain value. I tried to use the following formula but that returned the total for the full list.

{=COUNTA(IF('sheet1'!G4:G500<20000,'sheet1'!G4:G500,0)}

Anyone know where I went wrong?

Thanks

I have a large list. I need a formula that will count all the values in the list that are lower than a certain value. I tried to use the following formula but that returned the total for the full list.

{=COUNTA(IF('sheet1'!G4:G500<20000,'sheet1'!G4:G500,0)}

Anyone know where I went wrong?

Thanks

## Comment