Definitely. Even if I'm not in the mood and I have a headache or cramps, I get my boyfriend to have sex with me. Cramps and headaches may make it hard for you to get horny, but once you get turned on, your headache and cramps go away almost immediately.
The only downside for me is, they almost immediately come back after we're done. So, pop two advil before you have sex, and by the time sex is over with, the advil should start kicking in!