This is a slightly tricky one..

This is an example of what my data looks like:

__Database:__Column A: Country

Column B: Project

Column C: Data 1

Column E: Data 2

Column G: Data 3

... so on so forth. I have about 8 other columns of Data to be included

What i need is a formula that does the below:

- Based on the country in C1, and project in C2 --> ie Country A and Project ABC

- Take the average of Data 1 that is of Country A and Project ABC & Round off to nearest hundred --> Roundup(average of C8 and C10,-2)

+ the average of Data 2 that is of Country A and Project ABC & Round off to nearest hundred --> Roundup(average of E8 and E10,-2)

+ the average of Data 3 that is of Country A and Project ABC & Round off to nearest hundred --> Roundup(average of G8 and G10,-2)

+ the same for the other columns

= and the sum of this to be output into C3

I have tried to do it the above way but i get an error that the formula is too long because i'm basically applying the same thing to about 10 columns of data..each with the same 2 criteria..

Any help is greatly appreciated!!

Thank you all!