1. Home
  2. > aggregate numbers in excel

aggregate numbers in excel

The AGGREGATE function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using option 1, such as AGGREGATE 1, 1, ref1, hiding a column does not affect the aggregate sum value. But, hiding a row in vertical range does affect the

Get Price
contact us
Hi,may I help you with products, price, etc?