If I give each type of cost/revenue in the cash book a different letter code (in a separate column) what formulae do I use so that each cost category is picked up & summed in the accounts (located to the bottom of the cash book)?
If I give each type of cost/revenue in the cash book a different letter code (in a separate column) what formulae do I use so that each cost category is picked up & summed in the accounts (located to the bottom of the cash book)?
well it will be much easier if you add excel file.
but i think picot table will like you want..i guess
Like to say thanks ?Please use the star icon.
Hi PlantWild
Look at the SUMIF Worksheet Function.
For example:
Cost Codes are in Column A and the Cost Codes are "A", "B",and "C"
Amounts to be Summed are in Column C
In C52
In C53Please Login or Register to view this content.
In C54Please Login or Register to view this content.
etc, etcPlease Login or Register to view this content.
Last edited by jaslake; 06-05-2013 at 07:04 PM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks