For summarize in excell

February 14, 2015 at 03:44:52
Specs: Windows 7
I renew my report every month and I have to summarize all months numbers in a cell. I want to generate all past months informations in a cell autimacially. For example, if I put 1 in a space cell, excell must be summarize only information of January. And second month I will put 2 and excell must be summarize january and fevral months and so on.
Please, write me an easy formula if you know.
I know "If() formula but want easier.

See More: For summarize in excell

Report •

February 14, 2015 at 05:21:03
It is not clear what you are trying to do.

Are you entering your values (e.g. 1 and 2) in the same cell and expecting Excel to remember what was in that cell before the change? If so, that can not be done with a formula and is even difficult to do with a macro. Excel can't "remember" past values, they have to exist someplace in order for Excel to perform a calculation on them.

You say you "know IF() formula)". Perhaps you could explain how you are using IF to accomplish your goal and we'll see if we can suggest something "easier".

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question