Hi,
Do I understand correctly that you wish to extract all CC's income from the Income table and write it to the Income column under the CC header? Or is it that you need only the income for the period mentioned in the Cs. Table?
Then, same for Revenue.
Then, compare the two values?
Your worksheet would be clearer if you would populate it with a few data you extract / calculate manually and add an explanation on the side what you extracted / calculated.
A ratio, expressed as 3:5 is hard to do. Can you live with a percentage, instead?
Regards,
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)