Forum Discussion
Solved
Formula HELP!!
I need help with a formula I have been trying to figure out for 3 days. If you look at the example I have a "Plan" column that gets auto populated by certain criteria. This is our target date to ...
Okay, when
=SUMPRODUCT(ISNUMBER(SEARCH("Plan",$R$3:$BA$3))*($R$4:$BA$34>=(EOMONTH(CQ4,-1)+1))*($R$4:$BA$34<=EOMONTH(CQ4,0))*(ISBLANK(OFFSET($R$4:$BA$34,0,1))+ISNUMBER(OFFSET($R$4:$BA$34,0,1))*(OFFSET($R$4:$BA$34,0,1)>EOMONTH(CQ4,0))))We count blank cell and don't count cells with any text ("N/A" in particular)
You have terminated this conversation. Thus, I advise you to start anew. Otherwise, this thread might go on forever!
I figured it would be easier for everyone instead of having to re explain the entire situation.Twifoo