Creating data in a 2nd page that calculates sum of different categories of text

[blummin.eck]

Hi, Sorry for the lame question, but just started using excel, never needed it before. Anyway I would like to add a field in page 1 called "source" and based on that there will be 4 categories, then in page 2 a cell for each category that gives the sum of each of those categories. How would I go about that?Attachment 208001

[FDibbins]

blummin eck , all you needed to do was changethe thread title on your previous post, not start a new post. I will close your other thread so you can carry on here. but next time, just change the name, because duplicate threads are not aloowed here.

ok, on to your question...

Im not sure where you want to put the new column, or what your categories would be (it would help if you had offered at least some info on that).

What I have below, is the basis of what you need. I based my forumula on summing "Total Owed", and "Type".

On sheet2, in column A, enter any of the categories you have in "Type". then in B1, enter this...
=SUMIF('Balances Outstanding'!$I$5:$I$20,Sheet2!A1,'Balances Outstanding'!$D$5:$D$20)

Adjust the ranges as needed