2000 Pontiac Sunfire Low RPM / misfiring

Transmission problem
2000 Pontiac Sunfire 4 cyl Front Wheel Drive Automatic

I have a 2000 pontiac sunfire 2.2L that has been sitting for about a month and a half.
When I went to start it a few weeks ago it was misfiring and I couldn't get the car to drive faster than 40km an hour. A friend of ours told us that the 1&4 coil was faulty so we changed it along with the spark plugs and wires (which I can guarantee you have been changed properly). The car is still acting the same. The problem is still coming from the same coil but the coil is new. Is there another part connected to it that could be causing the problem?