Adding totals from daily receipts.

[marcel12]

Hi all,

I hope you can help me on this one...

My company issues daily receipts to the tax revenue in our country there will be a receipt for every day with the usages we have during out business.
Now I would like to make a totals at the end of the month for an easy overview but I can't figure out a simple way to do this. I know it's there but I just can't remember.

Of course I could type it all out but that would be 300 seperate inputs while I know it can be done more easy and hopefully also so I can teach it to other people in my office.

Please view the attached file. Like I said, I would like to have the totals of all info inside the table. total number of pax from every day, total spend on water etc. etc.

Thanks so much.

Cheers.

[humdingaling]

with your layout
just put this into ae6

Please Login or Register  to view this content.

and fill down

if you want to know how many days processed
same concept but with countif of a label

Please Login or Register  to view this content.

this one counts the number of "Total:"

[marcel12]

Awesome,

thanks loads!