Autosum

[PerryDaniel]

Hi

I have a spreadsheet that has a number of columns. What I would like t
do, is on a second sheet keep running totals. Heres my example.

COLUMN 1 COLUMN 2
AMOUNT STATU
100 Complete
200 Cancelled
300 Complete
400 Declined
500 In Progress
600 Cancelled
700 Complete

What I would like to do is have a total for each Status. If the statu
changes, the totals on the second sheet would update accordingly. An
help would be greatly appreciated.

Perry :confused

 

[Govind]

Hi,

In your second sheet, enter the unique status(like complete, cancelled,
declined etc) once in column A.say from cells A2 to A10 for eg.

Then in column B,enter the formula in cell B2 and copy it down till
required:

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

(To copy the unique statuses to sheet2, you can use autofilter and copy
unique records only).

Regards,

Govind

 

[Guest]

Govind,
How do you "copy unique records only" using auto filter?
TIA

 

[Govind]

Am sorry.that was a typo.It should be advanced filter.

Govind.

 

[Frank Kabel]

Hi
in addition you may consider using a pivot table for your report. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm