Forum Discussion
shirleyld21
Mar 16, 2021Copper Contributor
One cell to add several entries together automatically
Hello: I am new to the community and not well versed in Excel. I have a Dell Latitude E6400; Windows 10 OS; Office 365 Excel. I'm using a spreadsheet taken from an online template to record my 2...
Riny_van_Eekelen
Mar 16, 2021Platinum Contributor
shirleyld21 Please share the template itself or a link to the download. One would expect to see a sheet within the workbook where you can enter all your items as the receipts come in. Something like this:
Any proper template should be able to take this kind of input and summarise it by Category and Month. If yours can't, it's no good and you need to find one that does. Or create your own. It's not all that difficult. Many of the templates you find online often look very fancy and colourful but are overly complicated, lacking functionality and are near to impossible to customise. But that's just my personal opinion.
chahine
Mar 16, 2021Iron Contributor
try to use sumif and the criteria to be date