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?

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.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History