View Single Post
  #1   Report Post  
SigmaX
 
Posts: n/a
Default 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