Customized Sum Function

[Haree]

Hello I have a monthly worksheet, In which i enter my daily details. My data for everyday wouldn't be the same it would differ everyday. For example on a particular day i may have 10 entries on the other day i may only have 3 entries. So what i Do is I use excel shortcut ( Alt + =) to auto sum G column , it sums from the last formula automatically. Say i Autosum in G10 i would auto sum in L10 also and then i would subtract L10 from G10 in G11 (Basically G10 is cash inwards L10 is cash Outwards and G11 is cash in Hand) Is there a workaround that i can do in G11 to get the other parts automatically.
Thanks in Advance.Any form of help would be greatly appreciated.

 

[mamady]

Hi Dear,

Why won't you directly subtract the two values? i.e. in G11 =SUM(G1:G10)-SUM(L1:L10)

If the ranges change, you can put the formula beneath the maximum possible number of entries, create a Table, or put the output in another sheet.

Let me know if I understood your issue correctly.

Best Regards
M. Yusuf

 

[Haree]

Helloo Yusuf
Thanks for taking out time, i can sum directly but i would also like to know daily inflow and outflow that's the reason i do that. Will check on your solution. thank You

 

[mamady]

There are many ways to present the data if you share a screenshot of sample data I would be in a better position to suggest few ideas.

thank you