View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roy.okinawa
 
Posts: n/a
Default Help With Formula

I am trying to use this formula to sum/count from another worksheet. What am
I missing? I keep getting a FALSE answer instead of numbers.

=SUMPRODUCT(Overall!O31:O1026)=MONTH(C28)--(ISNUMBER(SEARCH(A35,O31:O1026)))