'How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
I am trying to create a Sub that places a SUMIF formula in a cell. I have reduced the problem to a simple setup:
Private Sub CommandButton1_Click()
Cells(2, 3).Formula = "=SUMIF(A1:A5;D1;B1:B5)"
End Sub
I get a 1004 Error.
I can run the same code but with the SUM function instead:
"=SUM(B1:B5)"
This does not produce an error. Thus I suspect the semicolons in my formula.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

![Picture of the spreadsheet [http://i.imgur.com/qVSoDkvm.png]](https://i.stack.imgur.com/VcKjG.png)