Sumif formula to add a specific amount automatically every month!

%3CLINGO-SUB%20id%3D%22lingo-sub-3089673%22%20slang%3D%22en-US%22%3ESumif%20formula%20to%20add%20a%20specific%20amount%20automatically%20every%20month!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3089673%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20formula%20can%20I%20use%2C%20for%20a%20certain%20amount%20to%20be%20added%20automatically%20with%20each%20passing%20month%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3089673%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3090117%22%20slang%3D%22en-US%22%3ERe%3A%20Sumif%20formula%20to%20add%20a%20specific%20amount%20automatically%20every%20month!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3090117%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1291623%22%20target%3D%22_blank%22%3E%40Aalex_Serban%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20there's%20a%20fairly%20straight%20forward%20answer%20to%20your%20question.%20The%20problem%2C%20however%2C%20is%20that%20your%20question%20is%20out%20in%20the%20middle%20of%20.....%20what%3F%20There's%20no%20context%20here.%20What%20does%20the%20spreadsheet%20look%20like%20into%20which%20you%20want%20this%20formula%20to%20go%3F%20A%20series%20of%20transactions%3F%20Daily%2C%20weekly%2C%20monthly%20cash%20flowing%20in%20and%20out%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20are%20we%20adding%20to%3F%20A%20balance%20column%20with%20other%20things%20going%20in%20and%20out%2C%20such%20that%20this%20automatic%20specific%20amount%20will%20be%20just%20one%20more%20transaction%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20us%2C%20in%20other%20words%2C%20a%20bigger%20picture.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi everyone,

 

What formula can I use, for a certain amount to be added automatically with each passing month? Thanks

1 Reply

@Aalex_Serban 

 

I'm sure there's a fairly straight forward answer to your question. The problem, however, is that your question is out in the middle of ..... what? There's no context here. What does the spreadsheet look like into which you want this formula to go? A series of transactions? Daily, weekly, monthly cash flowing in and out? 

 

What are we adding to? A balance column with other things going in and out, such that this automatic specific amount will be just one more transaction? 

 

Give us, in other words, a bigger picture.