I have a spreadsheet where I want all the values in Column D that corresponds to text "CURRENT CLOSING BALANCE" to total using SUMIF. If I use the SUMIF formula manually I get the correct vanswer, but gett zero when using the sumif formula in a macro. See attached workbook
My code is as follows:
Your assistance in resolving this will be most appreciatedHTML Code:Finalrow = Range("D65536").End(xlUp).Row Range("C" & Finalrow + 3).Value = "CURRENT CLOSING BALANCE" Range("D" & Finalrow + 3).Formula = "=sumif(C1:D" & Finalrow & ", ""CURRENT CLOSING BALANCE"", D1:D" & Finalrow & ")"