View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roy.okinawa
 
Posts: n/a
Default Finding total via entered text

I have a formula that will will search and give me the totals for the month
and text listed in specific cells:

=SUMPRODUCT(--(MONTH(O31:O1001)=MONTH(AV38)),--(ISNUMBER(SEARCH(AT43,S31:S1001))))

Is it possible to modify the month portion of this formula to check for a
number entered, such as 29025? So the formula would look something like
this:

=SUMPRODUCT(--(NUMBER(O31:O1001)=NUMBER(AV38)),--(ISNUMBER(SEARCH(AT43,S31:S1001))))