Formular

Posted by Murali on December 19, 2001 8:07 PM

please guide me how to combine sub total from another sheet.........and i want to auto update the subtotal

E.g

Departmet Jan Feb Mar Apr
Account 10(subtotal)
Maintenace 2(Subtotal)

Posted by IML on December 19, 2001 8:28 PM

You may be able to use sumif statments for this. For example, if your summary page is on one sheet, you could list your departments in column A. To get the total from sheet 2 you use the formula
=SUMIF(Sheet2!$A:$A,$A2,Sheet2!B:B)
where the department is listed in column A of sheet 2, and January sales in column B on sheet 2. A2 would be your department on the first sheet. If the format is similar, you could copy this formula for all months.

Good luck