I need a formula

[RGlade]

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

=SUMPRODUCT((MONTH(B206:B693)=1)*D206693)

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.

 

[Dave]

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

 

[RGlade]

It worked great. Thank you very much.