I need a formula

  • Thread starter Thread starter RGlade
  • Start date Start date
R

RGlade

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.
 
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.
 
Back
Top