Help me with Conditional Sum (please)

[Frank Kabel]

Hi
try something like
=SUMIF('sheet1'!B1:B1000,"Food",A1:A1000)

you may also consider using a pivot table for creating your summary
page. See
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
to get some starting information

 

[shadestreet]

I have numerical values in column A, and in colum B there are tex
classifications that define which category the numbers apply.

For example A1 value = $6, B1 = Food
A2 = $700, B2 = Mortgage
A3 = $50, B2 = Food

I have a summary page that I want to collect the totals for eac
category using conditional summing. Conditional Sum wizard isn't doin
anything for me though, any help is appreciated.

Thank

 

[CLR]

Take a look at Data > Subtotals............and just follow the
menus........I think it will give you what you're looking for.........

Vaya con Dios,
Chuck, CABGx3

 

[Debra Dalgleish]

List your categories on the Summary sheet (cells A2:A10 in this example)
In cell B2, on the Summary sheet, enter a SUMIF formula, referring to
your data on Sheet1:

=SUMIF(Sheet1!B:B,A2,Sheet1!A:A)

Select cell B2, and point to the fill handle,
at the bottom right of the cell
When the pointer changes to a black plus sign, double-click
to copy the formula down to the last category.