Embedded IF Statements

[financegrl]

Hello,

In the attached sheet I'd like to calculate the average of the values in Column B (Announced Total Value) for all of North America and the average for all of Europe. So far, I have the country corresponding to each value in Column A and am looking for the quickest way to pull out these averages by region. I think I'll need to do some sort of an IF statement embedded in an Average= formula, but I wanted to see if there are suggestions for the quickest way of doing this.

I'm also looking to calculate the average for all rows in which the value in Column A is at least 10% or greater than the value in Column C.

Thanks for the help!

[JieJenn]

Can't you just use use AvergeIF function?

[financegrl]

I'm not familiar with AverageIF, googling now...