PDA

View Full Version : Can I use if, sum, match and offset functions to do this??



Shaolin
09-21-2007, 06:53 AM
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
09-21-2007, 07:09 AM
Shaolin

Use those functions to do what?

Bob Phillips
09-21-2007, 07:16 AM
=SUMPRODUCT(--(B2:B200="Europe"),--(C2:C200="1st quarter"),A2:A200)

Shaolin
09-21-2007, 07:20 AM
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
09-22-2007, 02:59 AM
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