Sheffield is a river city in South Yorkshire and therefore will be quite chilly and wet. The surrounding hilly area protects the city from a certain amount of wind. It rains often, especially in October and January.
The average summer temperature is 16°C whilst the average winter temperature is 5 °C.
For the most reasonable weather, visit in late spring and summer.
Dress and plan accordingly.