Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A formula not working as the result of a previous formula? | Excel Discussion (Misc queries) | |||
Working an If formula | Excel Worksheet Functions | |||
formula not working | Excel Worksheet Functions | |||
Formula not working | Excel Worksheet Functions | |||
Formula Sometimes Working Sometimes Not | Excel Discussion (Misc queries) |