Thread: Summarizing category

Yo;

I have a sheet with two columns (Of significance), one denotes a dollar
amount, and the other an expense category.

Now I want another field, seperate from the above table, to print the
sum of all the dollar amounts from a particular category; i.e. for each
row in table; if ColumnA = "x", return the ColumnB

I'm a relative novice to spreadsheets, so be clear in your
explanations. Excel 2003.
Cheerio,
SigmaX

It sounds like you want a SumIf formula:

Suppose your categories are in A1:A4 and your dollars are in B1:B4 as follows:

A B
1 cat1 9
2 cat2 2
3 cat1 3
4 cat3 4
5
6 cat1 12

where the formula in B6 is: =SUMIF(A1:A4,A6,B1:B4)

Art

"SigmaX" wrote:

> Yo;
>
> I have a sheet with two columns (Of significance), one denotes a dollar
> amount, and the other an expense category.
>
> Now I want another field, seperate from the above table, to print the
> sum of all the dollar amounts from a particular category; i.e. for each
> row in table; if ColumnA = "x", return the ColumnB
>
> I'm a relative novice to spreadsheets, so be clear in your
> explanations. Excel 2003.
> Cheerio,
> SigmaX
>
>