Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|