Hi all,

Does anyone know how to count the number of cells, in a given row, that contains numbers smaller than a value in a given cell, in the same row, in Excel 2007?

I've tried "=COUNTIF(DE61:WV61;"<DD61")", but I'm not sure if it works, some values don't look right...

In addition to this, I don't know how to quickly copy the formula to the rest of the rows (just change the numbers). I've got a large dataset, ca 5000 rows and 500 columns, so I'd prefer not to do it manually...

Best regards,

Joel