Thread: Return a value if 2 Conditions apply
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_110_] John[_110_] is offline
external usenet poster
  
Posts: 22
Default Return a value if 2 Conditions apply
I want to return a value in a database listing if 2 conditions apply. This
value is Text. I have the following formula which works great when I am
search for a numeric field but doesn't work when the value is Text

=SUMPRODUCT(--(Consol.SalesDate=D$1)*(Consol.Area="EUR"),((Conso l.Comments)))

The Consol.Comments range is the value I am trying to return. If I use the
above formula it returns 0, not the correct answer



Reply With QuoteReply With Quote