Solved in 2003 excel how can I automatically sum the

July 18, 2011 at 17:59:57
Specs: Windows 2003
For month of April, I have 280 offices, sorted by office number (in Column B). Each office has several entries in varing amounts in column H. I want subtotals of each office and the subtotal put in column K. Is there an easy way to do this for 750 entries?

See More: in 2003 excel how can I automatically sum the

Report •


#1
July 18, 2011 at 20:30:53
✔ Best Answer
Review the SUMIF function in the Excel Help files to help you understand this suggestion.

Use an Advanced Filter (Data...Filter...Advanced Filter) to create a list of Unique Values (each office number) in a column e.g. starting in J1.

Then in K1 enter this and drag it down:

=SUMIF($B$1:$B750, J1, $H$1:$H$750)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question