I am able to look up single values that meet multiple criterion; but I would like to do more, I want to sum up values that meet two conditions - year and country like in my example. I tried it in my example with sumifs but it doesn't work, can you help me with this? thank you https://dl.dropboxusercontent.com/u/25073371/example.xlsx .
Asked
Active
Viewed 310 times
1 Answers
1
Sounds like a job for pivot table!
Your example is broken up into a format where you really only need to count a specific column (header:Belgium for instance), so I don't understand the particular need for the sumifs().
I could see using a sum of vlookups, or using an offset, but I think your best bet is probably a pivot table here.
Row labels filtered for 2005, for example, and then a sum for each country:
Maybe I'm misunderstanding your request, but pivot tables are usually very powerful when working with data sets this size or larger, rather than using formulas. Perhaps my pivot table isn't exactly what you want, but they are very versatile and will most likely be able to provide you with the characteristics of the data that you want.
Raystafarian
- 21,963
- 12
- 64
- 91