View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paige Paige is offline
external usenet poster
 
Posts: 270
Default Formula Not Working-Help Please!!!

Can someone tell me what is wrong with this code? I get an
application/object defined error on the 2nd row. Am trying to insert a sumif
formula into a cell, to add only those cells that do NOT have the word "MES"
in them.

Cells(Cells.Rows.Count, "T").End(xlUp).Offset(-1, 0).Select
Selection.Formula = "=SUMIF(I12:I50030,< ""MES"",T12:T50030)"

Thanks.....