the SUMIF function...
If just made it work, but it depends on how, exactly, you are specifying the month you want to refer to...
The basic syntax is;
=SUMIF(RANGE TO CHECK, VALUE TO LOOK FOR, RANGE TO ADD UP)
It's the middle bit you need to be careful about defining.
post back if you still need help, with more detail of how you determine which month to look for.