Can I use if, sum, match and offset functions to do this??

[Shaolin]

There is a table created

column A is the prices
column B is the regions (Europe, Americas, Asia)
column C is the quarter (i.e. 1st quarter, etc)

Can I use if, sum, match and offset functions or does this have to be done in VBA?

Thanks!

[Norie]

Shaolin

Use those functions to do what?

[Bob Phillips]

=SUMPRODUCT(--(B2:B200="Europe"),--(C2:C200="1st quarter"),A2:A200)

[Shaolin]

Shaolin

Use those functions to do what?

OMG. I can't believe I didn't finish my train of thought.

There is a table created

column A is the prices
column B is the regions (Europe, Americas, Asia)
column C is the quarter (i.e. 1st quarter, etc)

So, if Cell B3 and B6 and B9 read "Europe" and the corresponding cells in column C (C3, C6 and C9) read 1st quarter, 1st quarter and 3rd quarter then we'd like to print out the totals in column A onto say cell D15 (for Europe first quarter) and cell D17 for Europe 3rd quarter totals.

The idea is pretty simple, just to execute it.

[mdmackillop]

Hi Shaolin,
You presumably have this set up in a workbook. Why not post it to show exactly what you want, saving us the time and effort attempting to replicate your layout and data?
Regards
MD