Thanks for that. That is basically the formula I need but the problem with it is the number of rows alters all the time based on the amount of data that pulls through from an XML feed. Therefore the formula needs to vary depending on how many rows are in the table. i.e. like SUM(ABOVE) would do. Is that possible?
Thanks!
|