Formula for business profit/loss account

Hello,

I am in the process of making a profit/loss account in excel for my business.

In one tab, which I have named income I have used the data validation tool to select which category of income I have received (sale of goods, refunds, compensation, etc.). In the second tab, which I have named expenses I have again used the data validation tool to select the category of business expense (Stock, postage, etc). In the third tab, which is the profit loss account I have named each row with the types of income and types of expense that my business gets.

What I would like to know is how I can automatically add the numbers up from each category (from both the income and expense tab) and put the added numbers in the appropriate box in the profit/loss tab.

Would this be possible without using macro as I'm not very experienced with macros.

Thanks

John

The SUMIF function has worked a treat!

Thanks a lot!