I need a formula
 

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.

I need a formula
 

Hi,
Not quite sure if this is what you want, but try:
=SUMPRODUCT(--(ISNUMBER(FIND("April",C207:C209)))*(D207:D209))
or
=SUMPRODUCT(--(ISNUMBER(FIND("May",C207:C209)))*(D207:D209))
Change refs to suit.
Regards - Dave.

I need a formula
 

It worked great. Thank you very much.

"Dave" wrote:

Hi,
Not quite sure if this is what you want, but try:
=SUMPRODUCT(--(ISNUMBER(FIND("April",C207:C209)))*(D207:D209))
or
=SUMPRODUCT(--(ISNUMBER(FIND("May",C207:C209)))*(D207:D209))
Change refs to suit.
Regards - Dave.