# TIMEAGGREGATEÂ¶

Aggregates number values over a specified time period. Timeaggregate saves the aggregated interval values in a TargetRange. The returned value in the cell is aggregated over all numbers within the periode.

**Syntax**

TIMEAGGREGATE(DataCell, [Period, AggregationMethod, TimeSerial, Interval, TargetRange])

**Arguments**

Name |
Description |
---|---|

DataCell |
The data source cell which should evaluate to a number. All other values are ignored. |

Period |
Optional. The time period in seconds in which data is collected. Defaults to 60 seconds. |

AggregationMethod |
Optional. One of the predefined numbers which specifies the aggregation method to use. Defaults to 9. |

TimeSerial |
Optional. A serial number to use as key for each aggregated value. Defaults to NOW. |

Interval |
Optional. An interval in seconds at which values should be aggregated. Defaults to the specified period. To not loose any data, an Interval should always be a divisor of the Period. Note: Default Interval collects a different TargetRange as a handwritten equal Period. Default Interval: collects all values within the specified Period. Interval equals Period: aggregates all values to one value. |

TargetRange |
Optional. A cell range to write the aggregated values to. Collects aggregation intervals and displays them. Differs if interval is left blank (see interval). |

Sort |
Optional. Set to TRUE if values should be sorted by time. Most usefull if a custom TimeSerial parameter is provided. Defaults to FALSE. |

Limit |
Optional. Specifies the maximum number of values stored. If limit is reached the function returns a #LIMIT error. Defaults to 1000. |

**Aggregation Methods**

Number |
Method |
Description |
---|---|---|

0 |
NONE |
No aggregation is performed and the last valid value of specified DataCell is returned. |

1 |
AVERAGE |
Calculates the average of all received values. |

2 |
COUNT |
Counts the number of received values. |

3 |
COUNTA |
Counts all values which are not zero. |

4 |
MAX |
Determines the maximum of all received values. |

5 |
MIN |
Determines the minimum of all received values. |

6 |
PRODUCT |
Calculates the product of all received values. |

7 |
STDEV.S |
Calculates the standard deviation of all recieved values. |

8 |
STDEV.P |
Currently |

9 |
SUM |
Calculates the sum of all received values. |

**Return Value**

A number value aggregated over all values within specified period.

**Example**

Function |
Comment |
---|---|

=TIMEAGGREGATE(C2, 20) |
Calculates the sum of all values read from C2 over a period of 20 seconds. |

=TIMEAGGREGATE(C2, 20, 1,,2, D4:E14) |
Calculates the average each 2 seconds and writes roughly 10 values to target range D4:E14 |