Here's my previous formula and I need to adjust it a little bit and need some
help.

=SUMPRODUCT((MONTH(B206:B693)=1)*D206:D693)

I need it to look into a specific range of cells (example, C207:C209) and if
it says specifically "April work" or "May work" I want the range of
corresponding cells (example, c207:c209) to be put in a cell at the top that
corresponds with the heading January, February, etc.

So I guess the only difference is that I don't know how to tell it to look
for the specific word of the month followed by the word "work"

Hope that makes sense.
Thank you.