View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
TechieGirl TechieGirl is offline
external usenet poster
 
Posts: 10
Default How do I add LEFT to this array?

=SUMPRODUCT(--(ISERROR(SEARCH("Account Request",'Incident
Data'!$E$2:$E$5000))=FALSE),--(MONTH('Incident
Data'!$G$2:$G$5000)=MONTH(C$8)))

I want to modify it to restrict where it looks for "Account Request". I
figure add
LEFT('Incident Data'!$E$2:$E$5000,15) however that returns an error.
I also tried putting LEFT after SEARCH.

I am still very new to SUMPRoduct and I had help coming up with the formula
above; which works perfectly now.
I am also reading through:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

I don't want to break my wonderful "array"? Can anyone help?

Sonya