* Phonetically: The "y" in "comedy" is pronounced like a vowel sound, similar to the "i" in "bit". So, in that sense, it's acting as a vowel.
* Technically: In English, "y" is typically considered a consonant. It can act as a vowel in some words, but not always.
So, the answer is: It depends on your perspective.